Which two statements are true about the OPEN and FILEOPEN routines in the DBMS_LOB package?
(Choose two.)
A.
OPEN can be used to open only internal LOBs in the indicated mode.
B.
FILEOPEN can be used to open only external LOBs in the indicated mode.
C.
OPEN can be used to open internal and external LOBs in the indicated mode.
D.
FILEOPEN can be used to open internal and external LOBs in the indicated mode.
B, C
http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_lob.htm#i998745
http://www.toadworld.com/platforms/oracle/w/wiki/2686.dbms-lob-open.aspx
not understand why oracle has one FILEOPEN to open one BFILE, BFILENAME can open external file, OPEN can open BFILE, no need of having one GILEOPEN
FILENAME doesn’t open external file, it just initialize bfile, it doesn’t do the actual open