DESCribe is a SQL*Plus command. You can probably find what you are looking for by selecting from sys.all_tab_columns. There may be a DBA view that does the same thing, but I'm not up on them.
HTH, Dave On Apr 18, Mike Scott scribed: > 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. > > Mike Scott > QA Software Developer > BBC News Interactive > White City > London > UK > +44 20875 27288 > > > http://www.bbc.co.uk/ > > This e-mail (and any attachments) is confidential and may contain > personal views which are not the views of the BBC unless specifically > stated. > If you have received it in error, please delete it from your system. > Do not use, copy or disclose the information in any way nor act in > reliance on it and notify the sender immediately. Please note that the > BBC monitors e-mails sent or received. > Further communication will signify your consent to this. >
