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;

Posted by 공간사랑
TAG

댓글을 달아 주세요