-
"from" clause question
Hi,
How can I make the "FROM" clause variable using a cursor ??
Cursor c_one is
select tables
from all_tables
where ..... ;
r_c_one c_one%rowtype;
Cursor c_two is
select count(*)
from r_c_one.tables;
r_c_two c_two%rowtype;
Or... do I have to use dynamic SQL for this??
Please give me some examples on dynamic SQL ( its been ages ago I last used it ).
mvg GKramer
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|