OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » CLOB

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

CLOB [message #21154]

Tue, 16 July 2002 07:35

pvdalen
Messages: 14
Registered: April 2002

Junior Member

Hi all,

I've reviewed all the posts here regarding the CLOB datatype. What's not clear to me is how exactly one would query from a table with a CLOB column. Sorry to be obtuse, but I guess I need a more rudimentary explaination.

Also, how could I return the length of the data in this type of field?

Many thanks.

Report message to a moderator

Re: CLOB [message #21155 is a reply to message #21154]

Tue, 16 July 2002 08:18

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

SQL> desc test
 Name                                                  Null?    Type
 ----------------------------------------------------- -------- ---------------------------------
 CLOBCOL                                                        CLOB

SQL> select * from test;

CLOBCOL
--------------------------------------------------------------------------------
abcdefghiji

SQL> select * from test where
  2     dbms_lob.instr(clobcol, 'abc')>0;

CLOBCOL
--------------------------------------------------------------------------------
abcdefghiji

SQL> ed
Wrote file afiedt.buf

  1* select DBMS_LOB.GETLENGTH(clobcol) from test
  2  /

DBMS_LOB.GETLENGTH(CLOBCOL)
---------------------------
                         11

Report message to a moderator

Previous Topic:	MS-SQL float equivalent in Oracle
Next Topic:	dynamic sql for ASP access.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 03:37:39 CDT 2024