> -----Original Message----- > From: Marius Keraitis [mailto:[EMAIL PROTECTED]] > Sent: Friday, January 11, 2002 5:40 AM > 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.
Assuming you're using DBI, you should call prepare() to get a statement handle for your query. The use the various statement handle attributes to find out about the columns: $sth = $dbh->prepare('select * from foo'); $n = $sth->{NUM_OF_FIELDS}; # get number of columns print $sth->{NAME}[0]; # name of first column Look in the DBI docs; search for "Statement Handle Attributes" The other way would be to query the Oracle data dictionary views like USER_TAB_COLUMNS, but that's pretty ugly. > > If in Perl I could use the DESCRIBE commands there was no > problem, but this is > an Invalid statement..:( That's because DESCRIBE is a sqlplus command. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]