| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.tools -> Re: PL/SQL variable in a cursor as partition name? Oracle 8.1.7
Hi!
Could you use something like:
DECLARE
TYPE type_reference_cursor IS REF CURSOR;
l_cursor type_reference_cursor;
BEGIN
OPEN l_cursor FOR 'SELECT * FROM '||dynamic_string||';'
FETCH......
CLOSE l_cursor;
END;
/
Frank Received on Wed Jun 27 2001 - 15:13:11 CDT
 |
 |