Re: like clause in dbms_sql

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%');

• you can of course also use (not as good):
• dbms_sql.parse(l_crs, 'select table_name from all_tables where owner like ''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