Clob to table 
Author Message
 Clob to table
Is there any way to convert a clob to a searchable/sortable table?

I have clob data that I need to sort and search.  I would rather not
do it programmatically.  So, I was hoping that someone knows of a way
to do this using Oracle built in functions.

Thank you
Clayton Webb



Mon, 21 Feb 2005 06:00:43 GMT
 Clob to table

Quote:

> Is there any way to convert a clob to a searchable/sortable table?

> I have clob data that I need to sort and search.  I would rather not
> do it programmatically.  So, I was hoping that someone knows of a way
> to do this using Oracle built in functions.

> Thank you
> Clayton Webb

Can you perhaps provide a bit more information so that someone might
attempt to help you.

Lets start with the basics. Stuff like version and edition of Oracle.
Number of records. Size of the CLOBs. You know ... useful stuff.

Daniel Morgan



Mon, 21 Feb 2005 06:10:00 GMT
 Clob to table
What kind of data are you storing in CLOBs? XML? Then look at XDK.
Textual? Then interMedia Text/Oracle Text may be of help.
Spreadsheets? I doubt there is a simple way of working with them
as with structured data while storing them as unstructured data
(which CLOBs represent).

--

Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.


Quote:
> Is there any way to convert a clob to a searchable/sortable table?

> I have clob data that I need to sort and search.  I would rather not
> do it programmatically.  So, I was hoping that someone knows of a way
> to do this using Oracle built in functions.

> Thank you
> Clayton Webb



Mon, 21 Feb 2005 13:16:17 GMT
 Clob to table

Quote:


> > Is there any way to convert a clob to a searchable/sortable table?

> > I have clob data that I need to sort and search.  I would rather not
> > do it programmatically.  So, I was hoping that someone knows of a way
> > to do this using Oracle built in functions.

> > Thank you
> > Clayton Webb

> Can you perhaps provide a bit more information so that someone might
> attempt to help you.

> Lets start with the basics. Stuff like version and edition of Oracle.
> Number of records. Size of the CLOBs. You know ... useful stuff.

> Daniel Morgan

We are using Oracle 8.1.7.  The CLOBs are potentially very large
although I don't know how large yet.


Mon, 21 Feb 2005 20:43:36 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Oracle 8i CLOB - Unable to locate bfile to load into clob field in table

2. Oracle JDBC Clob ResultSet - Inserting a new CLOB

3. Need help mapping Oracle CLOB to DB2 CLOB in DataJoiner

4. Table.TField, Oracle8 and two CLOB-fields

5. data stored in various tables and fields versus xml file as a clob

6. Inserting CLOB data into different tables

7. Can't create table with CLOB..

8. can't create table with clob datatype?

9. Export and import tables which contains clob and long raw

10. space of context index and CLOB table

11. Update table with CLOB condition

12. Retrieve CLOB from stored procedure without granting SELECT on table


 
Powered by phpBB® Forum Software