Hi All,

Do u know how to make 22nd column a primary key if there is a table of
100 columns and you don't know the names of the columns?

If u do know plz reply ASAP…

Prabodh

"Prabodh" <prabodh_kelkar (AT) rediffmail (DOT) com> wrote

Pradodh,

The DESCRIBE command in SQL*Plus tells you the names of the columns for a
table.

You can also use the data dictionary view, USER_TAB_COLUMNS, to find the
name of the 22nd column of a table. Use the COLUMN_ID column of that view
to find the order that the column was created in.

Douglas Hawthorne