[EMAIL PROTECTED] wrote: > Good morning, > > I was given some tables on an Oracle database, but unfortunately I do > not know the field/column names of the table. I've made numerous > attempts to print such a list for a given table, but they never seem > to work. I've been trying SQL queries such as: > > SELECT column_name FROM user_tab_cols WHERE table_name = > 'mytable'sname' > > Sometimes I'm able to get them to run with no errors... yet no result > is produced when I try to print them. I'm not sure if there is some > trick with DBI that I'm overlooking. Any tips would be greatly > appreciated!
Well I suppose you could use DBI for this, but why? Just run "desc <tablename>" in sqlplus. - Philip