▼質問
Oracleのテーブル名を取得したいんだ。

どうしたらできるか教えてくれ！

▼回答
次のＳＱＬ文を参考にしてくれ！

select * from tab

TNAME | TABTYPE | CLUSTERID

select * from all_tables

OWNER | TABLE_NAME | TABLESPACE_NAME | CLUSTER_NAME | IOT_NAME | STATUS |
PCT_FREE | PCT_USED | INI_TRANS | MAX_TRANS | INITIAL_EXTENT | NEXT_EXTENT |
MIN_EXTENTS | MAX_EXTENTS | PCT_INCREASE | FREELISTS | FREELIST_GROUPS |
LOGGING | BACKED_UP | NUM_ROWS | BLOCKS | EMPTY_BLOCKS | AVG_SPACE |
CHAIN_CNT | AVG_ROW_LEN | AVG_SPACE_FREELIST_BLOCKS | NUM_FREELIST_BLOCKS |
DEGREE | INSTANCES | CACHE | TABLE_LOCK | SAMPLE_SIZE | LAST_ANALYZED |
PARTITIONED | IOT_TYPE | TEMPORARY | SECONDARY | NESTED | BUFFER_POOL |
ROW_MOVEMENT | GLOBAL_STATS | USER_STATS | DURATION | SKIP_CORRUPT |
MONITORING | CLUSTER_OWNER | DEPENDENCIES | COMPRESSION | DROPPED

select * from user_tables

TABLE_NAME | TABLESPACE_NAME | CLUSTER_NAME | IOT_NAME | STATUS | PCT_FREE |
PCT_USED | INI_TRANS | MAX_TRANS | INITIAL_EXTENT | NEXT_EXTENT | MIN_EXTENTS |
MAX_EXTENTS | PCT_INCREASE | FREELISTS | FREELIST_GROUPS | LOGGING | BACKED_UP |
NUM_ROWS | BLOCKS | EMPTY_BLOCKS | AVG_SPACE | CHAIN_CNT | AVG_ROW_LEN |
AVG_SPACE_FREELIST_BLOCKS | NUM_FREELIST_BLOCKS | DEGREE | INSTANCES | CACHE |
TABLE_LOCK | SAMPLE_SIZE | LAST_ANALYZED | PARTITIONED | IOT_TYPE | TEMPORARY |
SECONDARY | NESTED | BUFFER_POOL | ROW_MOVEMENT | GLOBAL_STATS | USER_STATS |
DURATION | SKIP_CORRUPT | MONITORING | CLUSTER_OWNER | DEPENDENCIES |
COMPRESSION | DROPPED

▼質問
Oracleのフィールド名を取得したいんだ。

どうしたらできるか教えてくれ！


▼回答
次のＳＱＬ文を参考にしてくれ！

SELECT * FROM ALL_TAB_COLUMNS WHERE UPPER(TABLE_NAME) = 'テーブル名'
ORDER BY COLUMN_ID ASC

---