OraFAQ Forum: SQL & PL/SQL » hi how to add 'space' to pl/sql block

Home » SQL & PL/SQL » SQL & PL/SQL » hi how to add 'space' to pl/sql block

Tue, 23 July 2002 13:23

rashme
Messages: 7
Registered: July 2002

Junior Member

hi i want to write a pl/sql block to display this
r
r a
r a s
r a s h
r a s h m
r a s h m e
please help
thanks in advance
rashme

Fri, 26 July 2002 01:07

chandra
Messages: 31
Registered: October 2000

Member

declare
v_temp varchar(10) := 'rashme';
begin
for i in 1..length(v_temp)
loop
dbms_output.put_line(substr(v_temp,1,i));
end loop ;
end;
/

Previous Topic:	Creating a user in a stored procedure - compile error
Next Topic:	help me

Goto Forum:

]

Current Time: Fri Apr 26 06:38:01 CDT 2024