Re: How to "order by" on long data type

From: Stan Brown <stanb_at_panix.com>
Date: 28 Aug 2001 09:21:32 -0400
Message-ID: <9mg5ss$d3m$1@panix2.panix.com>

In <9m6f8801dp3_at_drn.newsguy.com> Thomas Kyte <tkyte_at_us.oracle.com> writes:

>ops$tkyte_at_ORA817.US.ORACLE.COM> create or replace function get_search_condition(
>p_constraint_name in varchar2 ) return varchar2
> 2 as
> 3 l_data long;
> 4 begin
> 5 select search_condition into l_data
> 6 from user_constraints
> 7 where constraint_name = p_constraint_name;
> 8
> 9 return substr( l_data, 1, 4000 );
> 10 end;
> 11 /

Neat, and thanks.

One more question, could this function be made slightly more genereic? That is would it be possible to pass in the table name, and the collumn name? Received on Tue Aug 28 2001 - 08:21:32 CDT