반응형
SET LINESIZE 1000;
SET PAGESIZE 10000;
SELECT * FROM USER_TABLES ORDER BY TABLE_NAME;
COL DATA_TYPE FORMAT A50;
SELECT * FROM USER_TAB_COLUMNS ORDER BY TABLE_NAME;
SELECT * FROM USER_TAB_PARTITIONS ORDER BY TABLE_NAME;
SELECT * FROM USER_INDEXES ORDER BY TABLE_NAME;
COL COLUMN_NAME FORMAT A50;
SELECT * FROM USER_IND_COLUMNS ORDER BY TABLE_NAME, INDEX_NAME, COLUMN_POSITION;
SELECT * FROM USER_IND_PARTITIONS;
반응형
