On 04/18/2005 10:49 AM, Mike Scott said:
I'm using DBI and DBD::Oracle.
I'd like to be able to describe a table, but 'describe table' fails no
matter how I try to pass it to DBI.
I feel certain that this is a FAQ and so apologise in advance. I have tried to track down an answer, but "describe" and "table" are hard words to seach for. Can anyone help me out?
I just want the info describing the table that I can see in sqlplus.
You've gotten several responses that query Oracle metadata tables. A more portable method is to use the DBI methods.
http://search.cpan.org/dist/DBI/DBI.pm#Catalog_Methods
Search for the individual method names (e.g., column_info) for more details.
-- Mac :}) ** I usually forward private questions to the appropriate mail list. ** Ask Smarter: http://www.catb.org/~esr/faqs/smart-questions.html Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.
