Home » SQL & PL/SQL » SQL & PL/SQL » CLOB COLUMNS
CLOB COLUMNS [message #219677] Thu, 15 February 2007 07:17 Go to next message
libanori
Messages: 11
Registered: February 2007
Location: ireland
Junior Member

Hi,



How can you query a clob column?
One of the field has the data stored as type clob, and there are three records in, ie. department: Information system || type system | location | server room

Any way you can select which record within the column to query?

Thanks.
Re: CLOB COLUMNS [message #219683 is a reply to message #219677] Thu, 15 February 2007 08:54 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

A clob column is like a varchar2 column just bigger..

Work with the clob as you would with a string.

Re: CLOB COLUMNS [message #219705 is a reply to message #219683] Thu, 15 February 2007 10:38 Go to previous messageGo to next message
libanori
Messages: 11
Registered: February 2007
Location: ireland
Junior Member


This is how the record looks like:

complaint type = Complaint Appeal||Service Request Number = 1234||Department Name = INFORMATION SYSTEMS

If I want to extract the values of complaint type, service request number and department name, what is the best way to do?

There quite few different values......

Thanks
Re: CLOB COLUMNS [message #219720 is a reply to message #219705] Thu, 15 February 2007 11:57 Go to previous message
William Robertson
Messages: 1640
Registered: August 2003
Location: London, UK
Senior Member
Looks like someone has just gone ahead and made up a data format. You'll have to write something to parse it into something you can use.
Previous Topic: Sys ref cursor in for loop
Next Topic: Autotrace and explain Plan not found
Goto Forum:
  


Current Time: Tue Dec 06 00:04:57 CST 2016

Total time taken to generate the page: 0.06793 seconds