Daniel Morgan <dmorgan_at_exesolutions.com> wrote in message news:<3D3C911A.8D6E79D9_at_exesolutions.com>...
> 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
OK. I will try it. You are correct...unfortunately, I do not have
the ability to change the table...
Received on Tue Jul 23 2002 - 07:43:44 CDT
