Daniel:
This particular database is indeed 9i.
This is so cool! This little gem will come in handy.
I think I'll just wait 'till Pints has one of their
scotch-tasting extravaganzas. Might save me money in
the long-run :)
You know, in one of the original posts, Jacques said
"Shouldn't this column have been changed to a CLOB in
9.2?"
I double-checked, and even on a new database (not
migrated up from 8i, search_condition is a long. It
does make me wonder why Oracle didn't make that change
. . . .
Thanks for the code!
Barb
- Daniel Fink <Daniel.Fink_at_Sun.COM> wrote:
> For the past few days, I have been waging war with
> dbms_metadata (and I'm still standing!). One of the
> issues I had to deal with was
> the incorrect parsing of a view for output into a
> ddl call. Finally got that a workaround coded for
> that one this morning. Whew!
>
> Okay, so what does this have to do with Barb's
> problem? (Barb, you should stop reading now if you
> don't want to run up a serious tab
> at Pint's Pub). dba_views.text is a
> long...dba_constraints.search_condition is a long. I
> needed to perform character operations on
> the text, so I needed to convert it to a character
> string...not possible in one step. However, if you
> create a table (gtt in this
> case) where the text is stored as a CLOB, you can
> use the TO_LOB function on the insert to perform
> this conversion. Once you convert
> it to a CLOB, you can use TO_CHAR and apply
> character functions. Including = in a predicate!
>
> Here you go...it works for me..in a 9i db. (8i has
> clobs, but to_char does not appear to be able to
> handle them). If you are on 8i,
> sorry...
>
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Wed Jun 16 2004 - 16:09:29 CDT
