 | |
Looping through column values in a record without specifying columnnames?
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#41
 
| |||
| |||
|
Re: Looping through column values in a record without specifyingcolumn names? -
03-06-2008
, 05:06 AM
|
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. |
http://www.psoug.org/reference/dbms_sql.html
Note the defined data types.
Read through the various procedure names.
It isn't easy ... but it can be done unless I am totally
misunderstanding what you are trying to accomplish.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
#42
| |||
| |||
|
|
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/ora...03/042003.html
2. http://www.oracle.com/technology/ora.../o36plsql.html
search for :Obtaining the Names of Columns in a Dynamic Select
HTH
Thomas
#43
| |||
| |||
|
|
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/ora...03/042003.html
2. http://www.oracle.com/technology/ora.../o36plsql.html
search for :Obtaining the Names of Columns in a Dynamic Select
HTH
Thomas
#44
| |||
| |||
|
|
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/ora...03/042003.html
2. http://www.oracle.com/technology/ora.../o36plsql.html
search for :Obtaining the Names of Columns in a Dynamic Select
HTH
Thomas
#45
| |||
| |||
|
|
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/ora...03/042003.html
2. http://www.oracle.com/technology/ora.../o36plsql.html
search for :Obtaining the Names of Columns in a Dynamic Select
HTH
Thomas
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.