case wrong format

inanme

Member²
hi,

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;
it should be like this.

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;
 
Back
Top