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..

Server version: Apache/2.2.17 (Unix)Apache Tomcat/6.0.35java version "1.6.0_31"

--패키지 스펙 생성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;