일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | |||
5 | 6 | 7 | 8 | 9 | 10 | 11 |
12 | 13 | 14 | 15 | 16 | 17 | 18 |
19 | 20 | 21 | 22 | 23 | 24 | 25 |
26 | 27 | 28 | 29 | 30 | 31 |
- GIT
- grep
- IntelliJ
- Windows
- bash
- Mac
- JavaScript
- netsh
- VirtualBox
- context
- web.xml
- port
- ssh
- lsof
- find
- DB 도메인
- Eclipse
- xargs
- resource
- copy-dependencies
- Windows 10
- 네트워크
- 단축키
- maVen
- Source
- import
- profile
- 공통표준용어
- Quartz
- tomcat
- Today
- Total
목록DB (158)
develog
DECLARE FUNCTION FN_FORMAT_SCORE(P_SCORE NUMBER) RETURN VARCHAR2 IS V_SCORE VARCHAR2(20); BEGIN V_SCORE := NVL(P_SCORE, 0); V_SCORE := TRIM(TO_CHAR(V_SCORE, '9,990.9')); RETURN V_SCORE; EXCEPTION WHEN OTHERS THEN RETURN TO_CHAR(NVL(P_SCORE, 0)); END FN_FORMAT_SCORE; BEGIN DBMS_OUTPUT.PUT_LINE(FN_FORMAT_SCORE(NULL)); DBMS_OUTPUT.PUT_LINE(FN_FORMAT_SCORE('0')); DBMS_OUTPUT.PUT_LINE(FN_FORMAT_SCORE..
--패키지 스펙 생성CREATE OR REPLACE PACKAGE ATEST_PROCAS FUNCTION ATEST_FUNC1 RETURN NUMBER; END; --패키지 바디 생성CREATE OR REPLACE PACKAGE BODY ATEST_PROCAS FUNCTION ATEST_FUNC1 RETURN NUMBER IS BEGIN RETURN NULL; END; END; --패키지 삭제DROP PACKAGE ATEST_PROC;
--프로시저 생성CREATE OR REPLACE PROCEDURE ATEST_PROCISBEGIN NULL;END; --프로시저 삭제DROP PROCEDURE ATEST_PROC;
--펑션 생성CREATE OR REPLACE FUNCTION ATEST_PROCRETURN NUMBERISBEGIN NULL;END; --펑션 삭제DROP FUNCTION ATEST_PROC;
--인덱스 생성CREATE INDEX IDX_ATEST_01 ON ATEST(TITLE, USE_YN); --인덱스 삭제DROP INDEX IDX_ATEST_01; --인덱스 재생성ALTER INDEX IDX_ATEST_01 REBUILD;
--트리거 생성CREATE OR REPLACE TRIGGER ATEST_TRIGGERBEFORE INSERT OR UPDATE OR DELETE ON ATESTREFERENCING OLD AS O NEW AS NFOR EACH ROWDECLARE BEGIN IF INSERTING THEN INSERT INTO ATEST_LOG (SEQ, TITLE, NOTE, USE_YN, REG_TS, MOD_TS, LOG_TS, LOG_TYPE) VALUES (:O.SEQ, :O.TITLE, :O.NOTE, :O.USE_YN, :O.REG_TS, :O.MOD_TS, SYSTIMESTAMP, 'I'); END IF; IF UPDATING THEN INSERT INTO ATEST_LOG (SEQ, TITLE, NOTE,..