Re: DBI and using Oracle desc

Replies are listed 'Best First'.
Re^2: DBI and using Oracle desc by Anonymous Monk on Jun 28, 2007 at 13:22 UTC
The "desc" command simply describes a table - returning the column names, null or not null and field type. I've tried using "$sth = $dbh->table_info(",,USER\$")" (the table name is USER$) but I'm not getting anything useful from this.	[reply]
Re^3: DBI and using Oracle desc by Herkum (Parson) on Jun 28, 2007 at 14:02 UTC
All the information on tables, columns and databases are stored in SUPRISE other tables. You can write SQL queries against those system tables to get the information that you are interested without needing any special systems knowledge. As for the tables that you should be looking at, Try this page to get you started	[reply]
Re^3: DBI and using Oracle desc by Corion (Patriarch) on Jun 28, 2007 at 13:25 UTC
`$sth = $dbh->table_info(",,USER\$")` [download] does not do what you might think it does. Maybe you wanted to use the following? `$sth = $dbh->table_info('',undef,"USER")` [download] Maybe, for a first try, leave all the restrictions out and see what `->table_info` gives you.	[reply] [d/l] [select]