Re: Urgent help needed! Trouble getting column names from tables

2007-06-27 Thread Ron Savage
Hi Folks There are Perl modules designed to solve this problem. One is: http://search.cpan.org/~rsavage/DBIx-Admin-TableInfo-2.00/ -- Ron Savage [EMAIL PROTECTED]

Re: Urgent help needed! Trouble getting column names from tables

2007-06-27 Thread intel . g33k
On Jun 26, 10:25 am, [EMAIL PROTECTED] (Philip Garrett) wrote: > [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

RE: Urgent help needed! Trouble getting column names from tables

2007-06-26 Thread Garrett, Philip \(MAN-Corporate\)
[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

Re: Urgent help needed! Trouble getting column names from tables

2007-06-26 Thread Hal Wigoda
i think there is a syscolumns and systables tables that contain that data. On Jun 26, 2007, at 7:31 AM, [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 p

Re: Urgent help needed! Trouble getting column names from tables

2007-06-26 Thread Martin Evans
[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: SELEC