https://localhost:5500/em

• DBA
• H5 DB Import
• Oracle User관리
• Oracle설치

1. Maven Oracle JDBC
2. Schedule
3. Hint
4. Merge Statement
5. Trigger
6. Hash Join
7. Create Table
8. RDS DB Links
9. Table Space
10. Trunc
11. user_source 사용
12. Split To Table
13. Rollup
14. WM_CONCAT is gone in 12c
15. SQLLDR loader
16. SHA256 Package
17. TNS Names
18. Functions
19. 테이블정보 얻기
20. Use Comma
21. Timestampe를 이용한복구
22. XML SQL
23. Update Join
24. 프로시져 소스검색

       to_char(cnt_response / cnt_target * 100 ,'999,999,990.99')AS rate_response

ALTER TABLE supp_pfr ADD  grp_qty NUMBER(6,0);
comment ON COLUMN saled.reg_kind IS '세일등록구분';

CREATE UNIQUE INDEX AK_PEE_RATER_TARGET ON PEE_RATER_TARGET (APPR_ID, RATEE_EMP_NO)

SELECT ORA_ROWSCN, last_name FROM employees WHERE employee_id = 188;
 
SELECT SCN_TO_TIMESTAMP(ORA_ROWSCN), last_name FROM employees
   WHERE employee_id = 188;

Data Bulk Processing 시 유용한 방법인듯 싶으니 참고하세요..

-- Error Log Table 생성
DECLARE 
  -- Local variables here
  i INTEGER;
BEGIN
  -- Test statements here
  DBMS_ERRLOG.CREATE_ERROR_LOG('ZZZ', 'ZZZ_ERRLOG');
END;
 
 
 
-- 적용 예
INSERT INTO zzz
  (nm)
SELECT '1' FROM dual
UNION ALL
SELECT '12345678901' FROM dual
LOG ERRORS INTO  zzz_errlog(SELECT userenv('sessionid') FROM dual) REJECT LIMIT UNLIMITED;

20000~20999까지의 에러 숫자는 비워져 있다. 이 에러 숫자에 사용자 정의 오류 메시지를 실행 시킬 수 있다.

RAISE_APPLICATION_ERROR(-20001, 'asdf Error Message');

charset이 상이한 I/F에서 사용하여 한글 Encoding문제해결 utl_row.cast_to_raw ⇔ utl_row.cast_to_varchar2

UTL_RAW.CAST_FROM_BINARY_DOUBLE (n,endian) RETURN RAW;
UTL_RAW.CAST_FROM_BINARY_FLOAT (n, endian) RETURN RAW;
UTL_RAW.CAST_FROM_BINARY_INTEGER(n, endian) RETURN RAW;
UTL_RAW.CAST_FROM_NUMBER (n) RETURN RAW;
UTL_RAW.CAST_TO _BINARY_DOUBLE (n,endian) RETURN BINARY_DOUBLE;
UTL_RAW.CAST_TO _BINARY_FLOAT (n, endian) RETURN BINARY_FLOAT;
UTL_RAW.CAST_TO _BINARY_INTEGER(n, endian) RETURN BINARY_INTEGER;
UTL_RAW.CAST_TO _NUMBER (n) RETURN NUMBER;
UTL_RAW.CAST_TO_RAW (DATA) RETURN RAW;
UTL_RAW.CAST_TO_VARCHAR2 (r) RETURN VARCHAR;

SELECT A.TABLE_NAME, B.COMMENTS
  FROM ALL_TABLES A, ALL_TAB_COMMENTS B
 WHERE A.TABLE_NAME = B.TABLE_NAME
   AND A.TABLE_NAME LIKE 'LEM_COURSE%'
 ORDER BY A.TABLE_NAME;