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

> 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