how to execute varchar select sentence
602857Mar 26 2009 — edited Mar 27 2009Hi friends!
How to execute in PL/SQL the content of the varchar?
I know that it is posible with the function EXECUTE IMMEDIATE but it only works for INSERT, DELETE and UPDATE
But when the sentence is a SELECT, What function do I must to use for execute the SELECT sentence contents in varchar variable?
Is is posible make do it with the functions of the DBMS_SQL ?
Please show me an example.
Could you explain me one example with
I expect your prompt reply.
Thanks in advance
Best Regards