Hi,

I posted some things eariler to get some opinions on using CLOBS. We
have never done that here. I've been looking for a couple of hours
for some decent examples on how to insert, update and select data from
a CLOB column.

I also want to find some examples of using CLOB columns in PLSQL, so I
can see how to use the variable.

I see a lot of references to DBMS_LOB. Do I have to use that any time
I want to work with the CLOB?

I created a table with a CLOB column, put 10000 characters into that
column, but no matter what, could not get the 10000 back out....

I've seen a lot of pages, but I have not found any that give any real
good examples.

Does anyone have any URL's I can look at?

Thanks a lot!

On Mar 2, 1:24 am, mrdjmag... (AT) aol (DOT) com wrote:
Works for me:

CREATE TABLE testclob (bigcol CLOB);

INSERT INTO testclob VALUES (RPAD('v',4100,'ast quantities of text
v'));

SELECT * FROM testclob;

SQL*Plus will truncate the display according to SET LONG, which
defaults to 80:
http://download.oracle.com/docs/cd/B...89/ch12040.htm
Maybe this is what you're running into when you say you can't get 1000
characters back.

See CREATE TABLE in the SQL Reference for additional storage syntax
for CLOB columns, with examples. Also have a look at the Application
Developer's Guide - Large Objects:
http://download.oracle.com/docs/cd/B...b14249/toc.htm

What you can and can't do with them will depend on your database
version.

On Mar 2, 1:24 am, mrdjmag... (AT) aol (DOT) com wrote:
Works for me:

CREATE TABLE testclob (bigcol CLOB);

INSERT INTO testclob VALUES (RPAD('v',4100,'ast quantities of text
v'));

SELECT * FROM testclob;

SQL*Plus will truncate the display according to SET LONG, which
defaults to 80:
http://download.oracle.com/docs/cd/B...89/ch12040.htm
Maybe this is what you're running into when you say you can't get 1000
characters back.

See CREATE TABLE in the SQL Reference for additional storage syntax
for CLOB columns, with examples. Also have a look at the Application
Developer's Guide - Large Objects:
http://download.oracle.com/docs/cd/B...b14249/toc.htm

What you can and can't do with them will depend on your database
version.

On Mar 2, 1:24 am, mrdjmag... (AT) aol (DOT) com wrote:
Works for me:

CREATE TABLE testclob (bigcol CLOB);

INSERT INTO testclob VALUES (RPAD('v',4100,'ast quantities of text
v'));

SELECT * FROM testclob;

SQL*Plus will truncate the display according to SET LONG, which
defaults to 80:
http://download.oracle.com/docs/cd/B...89/ch12040.htm
Maybe this is what you're running into when you say you can't get 1000
characters back.

See CREATE TABLE in the SQL Reference for additional storage syntax
for CLOB columns, with examples. Also have a look at the Application
Developer's Guide - Large Objects:
http://download.oracle.com/docs/cd/B...b14249/toc.htm

What you can and can't do with them will depend on your database
version.

On Mar 2, 1:24 am, mrdjmag... (AT) aol (DOT) com wrote:
Works for me:

CREATE TABLE testclob (bigcol CLOB);

INSERT INTO testclob VALUES (RPAD('v',4100,'ast quantities of text
v'));

SELECT * FROM testclob;

SQL*Plus will truncate the display according to SET LONG, which
defaults to 80:
http://download.oracle.com/docs/cd/B...89/ch12040.htm
Maybe this is what you're running into when you say you can't get 1000
characters back.

See CREATE TABLE in the SQL Reference for additional storage syntax
for CLOB columns, with examples. Also have a look at the Application
Developer's Guide - Large Objects:
http://download.oracle.com/docs/cd/B...b14249/toc.htm

What you can and can't do with them will depend on your database
version.