Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Creating a cursor from a VARCHAR2
Hi,
I have a cursor like.....
CURSOR cur_get_info IS
SELECT * FROM .........; However, I'd like to create the cursor so that instead of typing in the SELECT statement, it comes from a string. i.e.
CURSOR cur_get_info IS
[my VARCHAR2];
Any advice would be great.
Thanks,
Allan Martin
Received on Wed Sep 19 2001 - 03:32:30 CDT