Galen Boyer <galenboyer_at_hotpop.com> wrote in message news:<ur8hvrn7z.fsf_at_hotpop.com>...
> On 22 Jul 2002, DelawareDH_at_yahoo.com 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.
>
> You could use XSQL. The page could execute a "select *" (Hm... do the
> good design rules apply with XSQL?) returning XML. Then, the XSQL page
> could reference an XSL page which could transform it to whatever html
> page format you want.
Great idea! I will try it...
Received on Tue Jul 23 2002 - 07:42:50 CDT
