| READING VARIABLE FIELD VALUES FROM A PL/SQL TABLE !!! [message #375271] |
Fri, 17 August 2001 12:36 |
sanjeev
Messages: 8
Registered: November 2000
|
Junior Member |
|
|
I have a specific question regarding the way a table which is created out of a SQL statement be read so that all the combinations are passed on to the calling procedure.....
For. eg. i have an sql statement which gives me ranges of values for year (say 1998-2002)and months(june-november) and other variables based on the SQL statement....
and based on this creates the fields in the table as
YEAR MONTH LOCATION
(with other fields depending on the sql statement)...
======================================================
1998 JUNE YORK
1999 JULY PITTSBURGH
2000 AUGUST CRAMROAD
2001 SEPTEMBER .....
=================================================
i know that by using the record set statement i can read each row in this table and pass those variable values to the calling procedure......but if i need to have a combination of all the values of a table field with other values in other table fields....for. eg.
for 1999 i want to have combinations like ...
1999,june,york
1999,june,pittsburgh
1999,june,cramroad....
and so on and then
for the next year 2000 have .....
2000,june,york
2000,june,pittsburgh
2000,june,cramroad.....and so on and so forth.....
...................
how can that be done and whether there is a function to do that within a table.........
PLZ. REPLY TO THIS AS soon as possible.....
thanx a lot
sanjeev
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
