On May 3, 12:37 pm, "sartaj..._at_gmail.com" <sartaj..._at_gmail.com> wrote:
> Hello,
>
> Can some one help me in executing a variable in oracle , in
> that variable a simple query is stored...., as given below
>
> begin
> :s:='select * from employee';
> end;
>
> now just tell me how to get the query result by the variable...
Look up 'execute immediate' of 'Native Dynamic SQL' in your
documentation.
If you are not prepared to do this, Oracle is not for you.
--
Sybrand Bakker
Senior Oracle DBA
Received on Thu May 03 2007 - 05:43:15 CDT
