How to execute a query in varchar2 ?
602857Jan 20 2009 — edited Jan 21 2009Hi everybody!!
Do you know how to execute a query which is in varchar2 variables?
i.e.:
EXECUTE IMMEDIATE ' SELECT SYSDATE FROM DUAL ' ;
Obviously the result must be a normal result of a query
If the query displays many columns, it must be do it.
Or is neccesary make a function which return a cursor?
Thank you in advance
I will aprreciate any help
Best Regards.