SQL Query

[tintin]

I want to select unique columns from many tables
within a schema. Pl. let me know.

[tamilselvan]

From the data dictionary?

[tintin]

to select from user defined tables

[pando]

dont understand your question at all

[tintin]

I've found the answer myself. To select unique column names
from multiple tables.

select distinct column_name from user_tab_columns
where table_name like '%staging%';

thanks.

[dknight]

You will retrieve columns from tables owned by your user, that is, the logon you used.

If you have DBA priviliges, select from DBA_TAB_COLUMNS and screen out users like SYS that are not relevant.

Good luck.