Re^2: Finding column info from Oracle tables

I've tried using "DESCRIBE USER\$" in a prepare statement and though it seems to "prepare" okay it fails on execution. Full error is "Can't execute SQL statement :: ORA-00900: invalid SQL statement (DBD ERROR: OCIStmtExecute)". I thought that would work but as it didn't I was hoping that I had the wrong syntax. Thanks anyway.

Comment on Re^2: Finding column info from Oracle tables

Replies are listed 'Best First'.
Re^3: Finding column info from Oracle tables by lbjay (Novice) on Jul 19, 2007 at 16:18 UTC
Try this: select column_name,data_type from user_tab_columns where table_name='<your tablename>'	[reply]