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]
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
[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
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
[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
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