Oracle PLSQL Large Objects 17 codes

  1. Home
  2. Oracle PLSQL
  3. Large Objects
1 BFILE Comparisons
2 BFILE File Operations
3 BFILENAME function
4 Call BFILENAME to get pointer to a BFILE
5 Create directory
6 Create or replace a directory
7 Create the BFILE directory
8 Difference between EMPTY_BLOB() & EMPTY_CLOB() and NULL
9 HEXTORAW function
10 Insert statement with HEXTORAW
11 Insert value to bfile column
12 LOB manipulations using DML statements
13 Two locators pointing to the same file
14 Update blob column to a new value with HEXTORAW
15 Update BLOB, CLOB cloumn
16 Use function empty_clob to insert empty clob value
17 Use Insert select statement with CLOB, BLOB and BFILE