JDBC로 연결되는 Tool 사용시 유용한 Altibase Query

--테이블크기 정보 조회 SELECT A.NAME TABLESPACE_NAME, B.TABLE_NAME TABLE_NAME, TRUNC((C.FIXED_ALLOC_MEM+C.VAR_ALLOC_MEM)/1024/1024,2) "ALLOC(MB)", TRUNC((C.FIXED_USED_MEM+C.VAR_USED_MEM)/1024/1024,2) "USED(MB)" FROM V$TABLESPACES A, SYSTEM_.SYS_TABLES_ B, V$MEMTBL_INFO C WHERE A.ID = C.TABLESPACE_ID AND B.TABLE_OID = C.TABLE_OID AND B.USER_ID != 1 AND B.TABLE_TYPE = 'T' UNION ALL SELECT A.NAME TABLESPACE..

• format_list_bulleted Blog/DB
• · 2013. 12. 3.
• textsms

Altibase Table 정보 조회 Query

가끔 유용하게 쓰일 때가 있다. ^^ SELECT A.USER_NAME AS 'USER_NAME', B.TABLE_NAME AS 'TABLE_NAME', C.COLUMN_ORDER + 1 AS 'NO', C.COLUMN_NAME AS 'COLUMN_NAME', CASE C.DATA_TYPE WHEN '1' THEN 'CHAR(' || C.PRECISION || ')' WHEN '2' THEN 'NUMERIC(' || C.PRECISION || NVL2(C.SCALE, ',' || C.SCALE, NULL) || ')' WHEN '4' THEN 'INTEGER(' || C.PRECISION || ')' WHEN '8' THEN 'DOUBLE' WHEN '9' THEN 'DATETIME' WHEN '12' ..

• format_list_bulleted Blog/DB
• · 2013. 11. 29.
• textsms