Re: Looping through column values in a record without specifying column names?
Date: Thu, 6 Mar 2008 06:31:46 -0800 (PST)
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.
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
Thomas Received on Thu Mar 06 2008 - 08:31:46 CST