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.
--
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.
Received on Mon Jul 22 2002 - 22:01:19 CDT
