[ ORACLE ] 顯示某Table 所有欄位語法

參考網站:
https://stackoverflow.com/questions/452464/how-can-i-get-column-names-from-a-table-in-oracle


記得 table_name 要大寫, ORACLE 很在意大小寫的 😃

SELECT table_name, column_name, data_type, data_length
FROM USER_TAB_COLUMNS
WHERE table_name = 'MYTABLE'
ORDER BY column_id