Oracle DESCRIBE command

[Anon]

I am looking for a way in php to DESC a table like you would with sqlplus for Oracle. I am trying to feed the sql statement a table and get information like field name length and the likes back.

[merkinmuffley]

I don't think you can use describe outside of sql*plus. what I do know is you can query the table dba_tab_columns to find out about any table.

select column_name, data_type, data_length, date_precision from dba_tab_columns where lower(table_name)='mytable' and lower(owner)='myuser';

hth

/nick