PL/SQL Block to Display

PL/SQL Block to Display

01:00 0 Comments A+ a-



Write a PLSQL block to display following:
        1
      1 0
      1 0 1
      1 0 1 0

Program:



declare
str varchar2(10):='1010';
begin
for i in 1..4
loop
dbms_output.put_line(substr(str,1,i));
end loop;
end;
/

OutPut:
      
      1
1 0
1 0 1
1 0 1 0
Unknown

Subscribe to: Post Comments (Atom)