Tuesday, June 7, 2011

How to leave a line in pl/sql block

Suppose if a user wants to display or leave a line between each pl/sql block then u can do it by implementing chr(10) which makes your output look welldefined
Example of plsql block without using chr(10):-
BEGIN
FOR i IN 1..6 LOOP
IF MOD(i,2) = 0 THEN
DBMS_OUTPUT.PUT_LINE('Loop counter is '|| i);
Else
dbms_output.put_line('loop counter is'||i);
END IF;
END LOOP;
END;
.
/
loop counter is1
Loop counter is 2
loop counter is3
Loop counter is 4
loop counter is5
Loop counter is 6



After using chr (10) ,the plsql block

BEGIN
FOR i IN 1..6 LOOP
IF MOD(i,2) = 0 THEN
DBMS_OUTPUT.PUT_LINE('Loop counter is ' i);
DBMS_OUTPUT.PUT_LINE(chr(10));
else
DBMS_output.put_line('loop counter is'||i);
dbms_output.put_line(chr(10));
END IF;
END LOOP;
END;
.
/
loop counter is1


Loop counter is 2


loop counter is3


Loop counter is 4


loop counter is5


Loop counter is 6



PL/SQL procedure successfully completed.

No comments:

Post a Comment