Re: Need help on Dynamic PL/SQL

From: Herbert Tessemaker <J.Hoekstra_at_civ.utwente.nl>
Date: 1998/01/19
Message-ID: <01bd24fb$48c679c0$7c025982@utciv2124.civ.utwente.nl>#1/1

Try this '''RAMESH'''

> 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.
>
Received on Mon Jan 19 1998 - 00:00:00 CST