Re: Need help on Dynamic PL/SQL

Thank you for all your replies. One of the newgroup member gave me a good solution.

Use ''' || 'Ramesh || ''''

Is the solution. Four apostrophy to represent one apostrophy.

Bye

On Fri, 16 Jan 1998 17:37:25 GMT, ubsram_at_pacific.net.sg (FIREWALL) wrote:

>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 Sun Jan 18 1998 - 00:00:00 CST