From: "Robert Malikian" <robertmalikian@hotmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Help with CLOB
Lines: 13
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <0WfP5.930$%b1.24034@news-1.opaltelecom.net>
Date: Sat, 11 Nov 2000 18:14:06 -0800
NNTP-Posting-Host: 62.24.149.192
X-Complaints-To: abuse@breathe.com
X-Trace: news-1.opaltelecom.net 973966076 62.24.149.192 (Sat, 11 Nov 2000 18:07:56 GMT)
NNTP-Posting-Date: Sat, 11 Nov 2000 18:07:56 GMT
Organization: Breathe www.breathe.com


Hi,

Is there a sweet way to see part of a clob; say something in line of

SELECT my_clob FROM my_table;

Is there a function like to_char?

Thanks in advanced.

Robert