Not a real Perl/Oracle hacker, but try if the select clause below produces
the data you need:
===============================
select
OWNER,
TABLE_NAME,
COLUMN_ID,
COLUMN_NAME,
DATA_TYPE,
DATA_LENGTH,
NULLABLE
from
all_tab_columns
order by
OWNER,
TABLE_NAME,
COLUMN_ID
=================================
Pekka Siiskonen
> -----Original Message-----
> From: Marius Keraitis [mailto:[EMAIL PROTECTED]]
> Sent: 11. tammikuuta 2002 12:40
> To: DBI Perl; Begginers Perl
> Subject: Column names and etc..
>
>
> Hi,
>
> I have a problem with getting colunm count and their names.
>
> I have to get the list of all tables in the users account (Oracle).
> This I do by selecting * from cat.
>
> Second step is to show every table contents (by clicking on
> link with table
> name).
> To do this I need to know how many columns is in table, and
> all names of columns
> in table.
>
> If in Perl I could use the DESCRIBE commands there was no
> problem, but this is
> an Invalid statement..:(
>
> One idea is to use cursors procedure, but it's all I know
> about this mistical
> procedure..:)
>
> Can anyone help me? I'll be very gladfull..
>
> MarioDaProgLamer.
>
