Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Thanks, but...

Thanks, but...

From: Piotr B. <piotrb_at_nie.spamuj.mnie>
Date: Fri, 28 Jan 2005 15:30:35 +0100
Message-ID: <ctdiae$7p9$1@atlantis.news.tpi.pl>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US