Please note that Oracle PL\SQL is *NOT* optimized for dynamic SQL! It
is possible to use dynamic SQL in PL\SQL, but the coding is somewhat
complex and performance will not be as good as with standard (static)
SQL statements that just accept input parameters to change the values of
bind variables.
Steve Feuerstein is a former Oracle employee and a PL\SQL expert! He
has written a number of books and articles on PL\SQL and some of them
cover how to do what you are asking for.
Try searching on his name or for books written by him.
-----Original Message-----
From: tarun-bansal
[mailto:oracledba-ezmlmshield-x30726400.[Email address protected]
Sent: Friday, June 29, 2007 8:51 AM
To: LazyDBA Discussion
Subject: Spam: help in Dynamic SQL
Hi
I want to get the values of one column from a table but dont know the
name of
column at the time of creation of procedute where i want the output.
I have to use Dynamic SQL, but the problem is, the output of that query
is more
than one records, so how can i get the required data by using dynamic
SQL.
Detail
Table is Month
There are 4 columns(A1,A2,A3,A4)
Query is << select p from month >>
and pass this p from the parameter of procedure.
So i want to get the output of that query....
Plz help me out..
Regards
Tarun Bansal
----------------------------------------------------------------------
This mail sent through Toaster-Horde (http://qmailtoaster.clikka.com/)
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
THE INFORMATION CONTAINED IN THIS E-MAIL MESSAGE AND ANY ATTACHMENTS SENT FROM GENTEX CORPORATION IS GENTEX CONFIDENTIAL INFORMATION INTENDED ONLY FOR THE PERSONAL USE OF THE INDIVIDUAL OR ENTITY NAMED ABOVE. If you are not the intended recipient, you are hereby notified that any review, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender by return e-mail, and delete this e-mail message and any attachments from your computer.
Oracle LazyDBA home page