Which two statements are true about the OPEN and FILEOPEN routines in the DBMS_LOB package?

Which two statements are true about the OPEN and FILEOPEN routines in the DBMS_LOB
package? (Choose two.)

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.

Show Hint

Leave a Reply 7

Your email address will not be published. Required fields are marked *

PIERO

PIERO

OPS
B , C as suggested link..

For example, consider a READ operation past the end of the BFILE value, which generates a NO_DATA_FOUND exception:

DECLARE
fil BFILE;
pos INTEGER;
amt BINARY_INTEGER;
buf RAW(40);
BEGIN
SELECT ad_graphic INTO fil FROM print_media WHERE product_id = 3106;
dbms_lob.open(fil, dbms_lob.lob_readonly);
amt := 40; pos := 1 + dbms_lob.getlength(fil); buf := ”;
dbms_lob.read(fil, amt, pos, buf);
dbms_output.put_line(‘Read F1 past EOF: ‘||
utl_raw.cast_to_varchar2(buf));
dbms_lob.close(fil);
END;

Reply

PIERO

PIERO

OPEN Procedures

This procedure opens a LOB, internal or external, in the indicated mode. Valid modes include read-only, and read/write.

Syntax

DBMS_LOB.OPEN (
lob_loc IN OUT NOCOPY BLOB,
open_mode IN BINARY_INTEGER);

DBMS_LOB.OPEN (
lob_loc IN OUT NOCOPY CLOB CHARACTER SET ANY_CS,
open_mode IN BINARY_INTEGER);

DBMS_LOB.OPEN (
file_loc IN OUT NOCOPY BFILE,
open_mode IN BINARY_INTEGER := file_readonly);

Reply

Путин В.В

Путин В.В

Пьеро – мудак

Reply