Re: Somehow dynamically extract 140+ table columns so I can fill a web page with the column data

DCCoolBreeze wrote:

> I have a table that contains more than 140 columns. I need to display
> the column names and their respective values given some criteria in a
> web page table via PLSQL. Is there a straight forward way to
> reference the column values? I can pretty easily get the column names
> via DBMS_SQL. The difficult part is extracting the data. The columns
> are of various types and lengths so I cannot generically define a
> PLSQL table.
>
> Help!!!!
>
> Thanks in advance
>
> David

One way would be to write a procedure in the database and select from an output produced useing a REF CURSOR.

There are many others.

But 140 columns in one table? I'd think long and hard about normalization.

Daniel Morgan Received on Mon Jul 22 2002 - 18:12:27 CDT