Need help on Dynamic PL/SQL

I need to concentenate a string with the following syntax. Please advice. The output I desire is created dynamicall via PL/SQL

This is the output I desire,

SELECT * FROM STUDENT_TABLE WHERE NAME = 'RAMESH' My sring will be assigned.

sel_store := 'SELECT * FROM STUDENT_TABLE WHERE ' || NAME || '=' || 'RAMESH' I need RAMESH to be represented as 'RAMESH'

How do I do it. The apostrophy is a controlled syntax in ORACLE.

Please advice as it is URGENT.

Thank you.

e-mail : ubsram_at_pacific.net.sg Received on Fri Jan 16 1998 - 00:00:00 CST