Re: Looping through column values in a record without specifying column names?
Date: Thu, 6 Mar 2008 06:31:46 -0800 (PST)
Message-ID: <43525db0-aecb-48a1-85b5-89ccbe106561@e31g2000hse.googlegroups.com>
On Mar 6, 5:16 am, dana..._at_yahoo.com wrote:
> Daniel, I'm going to look for your code and try it out today. If in
> the mean time you want to post a snippet here, that would be great.
> Evidently I'm not the only one confused about accomplishing this task
> through PL/SQL.
>
> If it can be done, it would be great to post the code here for others
> to learn from.
Dana,
As I said before, the only method I know of is to use :
DBMS_SQL with describe_columns parocedure.
Look at the examples:
1. http://www.oracle.com/technology/oramag/code/tips2003/042003.html
2. http://www.oracle.com/technology/oramag/oracle/06-may/o36plsql.html
search for :Obtaining the Names of Columns in a Dynamic Select
HTH
Thomas
Received on Thu Mar 06 2008 - 08:31:46 CST