Friday, April 15, 2011

Oracle: Select column names for a specific table

select distinct column_name from all_tab_columns
where table_name = upper('country')
order by column_name asc

No comments:

Post a Comment