tnsnames;ora:

DAYO =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.1.182)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = DAYO.localhost)

    )

  )

CLOBS

INSERT INTO clobs VALUES (1, 'interactive', 'a very short clob');

UPDATE clobs SET c = c || ', but not quite so short now';

SELECT * FROM clobs;

UPDATE clobs SET c = UPPER(c);

SELECT * FROM clobs;

To get a CLOB from a file... 

BFILE

 insert into bfiles values (1, 'declaration.txt', bfilename('MYLOBS','declaration.txt'));

(directory is case-sensitive!)

now what can you do with it?]]> Mon, 12 May 2008 20:11:31 +0000 add http://dayo.pbwiki.com/Meetings email.hidden@example.com (Catherine Devlin) Catherine Devlin edited Meetings Dayton OH 45402 USA
(937) 222-3663
Meething3NotesMeeting3Notes
Past Meetings
Dayton-OracleSIG(DAY-O)Meeting#2
]]> Mon, 12 May 2008 20:04:27 +0000 mod http://dayo.pbwiki.com/Meething3Notes email.hidden@example.com (Catherine Devlin) Catherine Devlin added Meething3Notes

tnsnames;ora:

DAYO =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.1.182)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = DAYO.localhost)

    )

  )

DAY-O LOB exercises

Pull in a LOB with DBMS_LOB

Browse the LOBs with an ApEx application

CLOBS

INSERT INTO clobs VALUES (1, 'interactive', 'a very short clob');

UPDATE clobs SET c = c || ', but not quite so short now';

SELECT * FROM clobs;

UPDATE clobs SET c = UPPER(c);

SELECT * FROM clobs;

BFILE

 insert into bfiles values (1, 'declaration.txt', bfilename('MYLOBS','declaration.txt'));

(directory is case-sensitive!)

now what can you do with it?

select id, source, dbms_lob.fileexists(f) from bfiles;