1.

Which Functions Should Be Used Before Performing Data Manipulation On Bfiles?

Answer»

FOLLOWING are the procedures or functions of the DBMS_LOB package that should be used before manipulating the BFILE DATA:

  •  FILEOPEN— Opens files
  •  FILEGETNAME—GeXs the filename
  •  FILEEXISTS —CHECKS whether the file exists
  •  FILEISOPEN— Checks whether the file is OPEN

These procedures are used, as Oracle does not maintain the INTEGRITY of the external file; only the pointer is maintained.

Following are the procedures or functions of the DBMS_LOB package that should be used before manipulating the BFILE data:

These procedures are used, as Oracle does not maintain the integrity of the external file; only the pointer is maintained.



Discussion

No Comment Found