ÇÁ·Î½ÃÁ®¸¦ ÀÌ¿ëÇϴ°ÍÀÌ ³ªÀ»µíÇÕ´Ï´Ù.
CREATE OR REPLACE PROCEDURE SUB_ADDNUM_P01 AS
-- *-------------------------------------------------------------------------*/
C_DEAL_DAY CHAR ( 8); -- ÀÏÀÚ
N_CNT NUMBER( 5); -- Áõ°¡µÇ´Â ¼ýÀÚ?
-- /*-----------------------------------------------------------------------*/
BEGIN
-- /*-----------------------------------------------------------------------*/
C_DEAL_DAY := '20060101' ;
N_CNT := 0 ;
-- /*-----------------------------------------------------------------------*/
FOR N_CNT IN 1..10 LOOP
/* ÃÑ 10 ¹øÀ» ¹Ýº¹ÇÏ¸é¼ ¹Ýº¹Ã³¸® */
BEGIN
INSERT INTO AAA VALUES ( C_DEAL_DAY , N_CNT+1 , N_CNT+2 , N_CNT ) ;
END ;
DBMS_OUTPUT.put_line ( TO_CHAR(TO_DATE(C_DEAL_DAY,'YYYYMMDD'),'YYYYMMDD') ||' # ==> ' || N_CNT);
C_DEAL_DAY := TO_CHAR(TO_DATE(C_DEAL_DAY,'YYYYMMDD')+1,'YYYYMMDD') ;
END LOOP;
END;
/
|
|
|