SET LINESIZE 32000;
SET PAGESIZE 40000;
SET LONG 50000;
SELECT column_name
FROM USER_TAB_COLUMNS
WHERE table_name = 'TABLE_NAME'
order by COLUMN_NAME
SET PAGESIZE 40000;
SET LONG 50000;
SELECT column_name
FROM USER_TAB_COLUMNS
WHERE table_name = 'TABLE_NAME'
order by COLUMN_NAME
0 Comment to "SQL ORACLE select column name of a table"
Post a Comment