Barb,
Guess what... search_condition (and dba_views.text) are still LONG in 10g!
Dan
Barbara Baker wrote:
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
---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------