OraFAQ Forum: SQL & PL/SQL » how can i print name

Home » SQL & PL/SQL » SQL & PL/SQL » how can i print name

Thu, 18 July 2002 20:37

rashme
Messages: 7
Registered: July 2002

Junior Member

hi friends

how can i print my name in a triangle shape please any one help me to write procedure for it

thank u in advance
rashme

Tue, 23 July 2002 06:06

saravanan
Messages: 70
Registered: October 2000

Member

hi
try this

declare
v_name varchar2(20):='RASHME';
begin
for i in 1..length(v_name) loop
dbms_output.put_line(substr(v_name,1,i));
end loop;
end;

Previous Topic:	How to see my procedure/function code ?
Next Topic:	Re: About insert data into a table which created in pl/sql

Goto Forum:

]

Current Time: Tue Apr 23 11:08:38 CDT 2024