Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Thanks, but...
nomorekiss_at_yahoo.com wrote:
> ops$tkyte_at_ORA920LAP> create or replace function get_search_condition(
> p_cons_name in varchar2 ) return varchar2
> 2 authid current_user
> 3 is
> 4 l_search_condition user_constraints.search_condition%type;
> 5 begin
> 6 select search_condition into l_search_condition
> 7 from user_constraints
> 8 where constraint_name = p_cons_name;
> 9
> 10 return l_search_condition;
> 11 end;
> 12 /
Thanks, but:
Piotr B. wrote:
> I'd prefer not to create any PL/SQL functions/procedures,
> since I've got read-only access to the database...
Received on Fri Jan 28 2005 - 08:30:35 CST