DESC: Method for listing field names only

In many cases, we need a table field list, such as the write control file CTL...

DESC does not have a parameter to list only its NAME

No. Let's access its dictionary table.

USER_TAB_COLS

USER_TAB_COLUMNS

SQL> select column_name from user_tab_columns s where table_name = 't_ CACHE_ZCPROJECT ';

It is often found that the sorting of COLUMN_NAME is different from that of DESC T_CACHE_ZCPROJECT.

By default, it is LAST_ANALYZED sorting.

Order By s. COLUMN_ID is the same as DESC.

In the PL/SQL developer query window, you can directly copy data. If SQL plus is used for processing

Set linesize 80
Set describe depth 2
SET DESCRIBE INDENT ON
SET DESCRIBE LINE OFF