착한사기꾼
Database 검색 결과, 3
Table Comment, Column Comment
1. Table Comments SELECT T1.TABLE_NAME, T2.COMMENTS TABLE_COMMENT FROM USER_TABLES T1, USER_TAB_COMMENTS T2WHERE T2.TABLE_NAME(+) = T1.TABLE_NAME AND T1.TABLE_NAME = [테이블이름]ORDER BY 1, 2; 2. Select Column CommentsSELECT T.COLUMN_NAME AS PHYSICAL_NAME, C.COMMENTS AS LOGICAL_NAME, T.DATA_TYPE AS TYPE, CASE WHEN T.DATA_TYPE = 'NUMBER' THEN T.DATA_PRECISION ELSE CASE WHEN T.CHAR_LENGTH != 0 THEN T.C..오라클에서 테이블 사이즈 계산
-- Tables + Size MBSELECT OWNER, TABLE_NAME, ROUND((NUM_ROWS*AVG_ROW_LEN)/(1024*1024)) MB FROM ALL_TABLES WHERE OWNER = 'CNBC' -- Exclude system tables. AND NUM_ROWS > 0 -- Ignore empty Tables. ORDER BY MB DESC -- Biggest first.; --Tables + RowsSELECT OWNER, TABLE_NAME, NUM_ROWS FROM ALL_TABLES WHERE OWNER = 'CNBC' -- Exclude system tables. AND NUM_ROWS > 0 -- Ignore empty Tables. ORDER BY NUM_R..
착한사기꾼