오라클 프로시져 예제

오라클 프로시져 예제

CREATE OR REPLACE PROCEDURE SPILT_DATA

IS

--CURSOR CUR_DATA(I NUMBER) IS SELECT DBMS_LOB.SUBSTR(TEXT_FIELD, 2000,1) AS B FROM TEMP;

BUFFER_STR VARCHAR2(4000):= '';

QUESTION VARCHAR2(4000):= '';

CLUE VARCHAR2(4000):= '';

ANS1 VARCHAR2(4000):= '';

ANS2 VARCHAR2(4000):= '';

ANS3 VARCHAR2(4000):= '';

ANS4 VARCHAR2(4000):= '';

EXAMNAME VARCHAR2(4000):= '';

EXAMNAME1 VARCHAR2(4000):= '';

STARTVALUE NUMBER :=NULL;STARTVALUE2 NUMBER :=NULL;

expl VARCHAR2(4000):= '';

RIGHT_ANS1 VARCHAR2(4000):='';

cnt number :=1;

tmp VARCHAR2(4000):= '';

BEGIN

 DELETE FROM GISA_EXAM;

 FOR EXAM IN 1..1 LOOP

     STARTVALUE:=NULL;

STARTVALUE2:=null;

FOR VAL IN 1..100 LOOP

BEGIN

SELECT