hi,
Pl/SQL developer can not format this code
it should be like this.
Pl/SQL developer can not format this code
Code:
CREATE OR REPLACE PROCEDURE NONAME IS
BEGIN
FOR data IN 1 .. 10 LOOP
CASE data
WHEN 1 THEN
DBMS_OUTPUT.PUT_LINE(data);
END CASE; END LOOP;
EXCEPTION
WHEN case_not_found THEN
dbms_output.put_line(Sqlerrm);
END;
Code:
CREATE OR REPLACE PROCEDURE NONAME IS
BEGIN
FOR data IN 1 .. 10 LOOP
CASE data
WHEN 1 THEN
DBMS_OUTPUT.PUT_LINE(data);
END CASE;
END LOOP;
EXCEPTION
WHEN case_not_found THEN
dbms_output.put_line(Sqlerrm);
END;