Re: Need help on Dynamic PL/SQL

Hi

One of the *goodies* you can find in the PL/SQL library on the Oracle Utilities page of my web site is a funtion *in_quotes*. (http://members.aol/jomarlen/

This saves working out how many quotes you need to achieve your value enclosed in quotes.

Ramesh's string assign would be simply

sel_store := 'SELECT * FROM STUDENT_TABLE WHERE ' || NAME
>|| '=' || in_quotes('RAMESH');

John Received on Tue Jan 20 1998 - 00:00:00 CST