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

Home -> Community -> Usenet -> c.d.o.misc -> Re: like clause in dbms_sql

Re: like clause in dbms_sql

From: Marc Billiet <Marc.Billiet_at_hae.hydro.com>
Date: Tue, 06 Oct 1998 07:38:28 +0100
Message-ID: <3619BAE4.6B4A@hae.hydro.com>


Hello,

That's in fact very easy (I didn't test this, but it should work):

DECLARE
  l_crs INTEGER;
BEGIN
  l_crs := dbms_sql.open_cursor;
  dbms_sql.parse(l_crs, 'select table_name from all_tables where owner like :p_owner');
  dbms_sql.bind_variable(l_crs, 'p_owner', 'SYS%');

Marc

umagri_at_my-dejanews.com wrote:
>
> hi all,
> i would like to know how do i get to parse a stmt that contains the like(%)
> clause in dbms_sql.parse()
> thanks very much,
> --ugri
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Oct 06 1998 - 01:38:28 CDT

Original text of this message

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