pl/sql Procedure
HI,
i have table like this.
CREATE TABLE pr_temp(pr_no NUMBER,f_flg NUMBER(1));
INSERT INTO pr_temp VALUES(11,0);
INSERT INTO pr_temp VALUES(12,1);
INSERT INTO pr_temp VALUES(13,0);
INSERT INTO pr_temp VALUES(14,0);
INSERT INTO pr_temp VALUES(15,0);
INSERT INTO pr_temp VALUES(16,1);
INSERT INTO pr_temp VALUES(17,0);
INSERT INTO pr_temp VALUES(18,0);
INSERT INTO pr_temp VALUES(19,1);
INSERT INTO pr_temp VALUES(20,0);
INSERT INTO pr_temp VALUES(21,0);
INSERT INTO pr_temp VALUES(22,0);
INSERT INTO pr_temp VALUES(23,1);
INSERT INTO pr_temp VALUES(24,1);
INSERT INTO pr_temp VALUES(25,1);
0-success
1-failure
SELECT * FROM pr_temp WHERE f_flg=0 ORDER BY pr_no;
output FOR success;
-------------------
11-15;17-18;20-22;
(ie)11 TO 15 datas are success records,.....
SELECT * FROM pr_temp WHERE f_flg=1 ORDER BY pr_no;
output FOR failure;
------------------
12;16;19;23-25;
(ie)23 TO 25 datas are failure records,.....
i need a pl/SQL PROCEDURE.Please help me.
by
siva