Home » SQL & PL/SQL » SQL & PL/SQL » cursor
cursor [message #39087] Fri, 14 June 2002 02:23 Go to next message
Mahesh
Messages: 90
Registered: January 2001
Member
hi,

I have to create a procedure with parameters.
one of the parameter is table name.
depending on the table name , i have to declare a cursor
how can i do it?

say there are 2 tables i work on.

and i do different processing on them for which i need different cursor declarations.

Please post ur reply soon

Report message to a moderator

Re: cursor [message #39094 is a reply to message #39087] Fri, 14 June 2002 08:32 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Dynamic SQL:

open c for 'select col1 from ' || p_table_name;

Report message to a moderator

Previous Topic: date
Next Topic: SQL PLUS W Error - Urgent
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 01:04:29 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.