The process of querying and outputting table structure data from the Oracle database under sqlplus

The system table for storing the attribute names in the Oracle table is dba_tab_columns. You can check all the attribute names from this table,

Set pagesize 0 -- set the page size. 0 indicates no limit. If it is set to 10, the second blank row after 10 rows of data;
Set num 18; set the number length. If it is not large enough, use scientific notation;
Set heading off; set not to question header,
Set feedback off; no response is required;
Set term off;
Set trimspool on;
Spool C:/data.txt;
@ SQL/1000. SQL; set the file name of the spool query statement. You can add a path such as @ C:/SQL .txt.
Spool off;
Exit;