Re: How to include a '%' in a PL/SQL script?

"Noel" <tbal_at_go2.pl> wrote in message news:c4e4iq$h02$1_at_inews.gazeta.pl...
|
| > SQL> SELECT parent_id FROM family WHERE company_id like '%1234';
| > identify :=
| > 'SELECT parent_id FROM family WHERE company_id like ''%:here''';
|
| identify :=
| SELECT parent_id FROM family WHERE company_id like
''%'||:here||''';
|
| What's ':here' in this procedure?
| What if that select statetment returns more than one, or returns no rows?
| --
| TomekB
|
|

apparent :here is a bind variable

;-{ mcs Received on Wed Mar 31 2004 - 05:32:52 CST