Home » SQL & PL/SQL » SQL & PL/SQL » Using dynamic table and column names in a stored procedure
icon5.gif  Using dynamic table and column names in a stored procedure [message #220302] Tue, 20 February 2007 02:52 Go to next message
abis123
Messages: 31
Registered: February 2007
Member
I am after a way of using dynamic table and column names in a stored procedure. I wish to pass in a table name and 2 column names through parameters.
icon10.gif  Re: Using dynamic table and column names in a stored procedure [message #220315 is a reply to message #220302] Tue, 20 February 2007 03:50 Go to previous message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Are you asking permission from anybody??
You can pass them.
I hope you are using them in DML's. If so, you can use dynamic sql.

By
Vamsi
Previous Topic: plsql records
Next Topic: Performance Tuning
Goto Forum:
  


Current Time: Tue Dec 06 06:14:01 CST 2016

Total time taken to generate the page: 0.10291 seconds