Display your name 10 times in PL/SQL

Write a PL/SQL anonymous block with exception handling to print your name 10 times?

Showing Answers 1 - 24 of 24 Answers

TRINADH

  • Nov 23rd, 2017
 

declare
v_ename varchar2(200);
begin
v_ename:=trinadh;
for i in 1..10
loop
dbms_output.put_line(v_ename);
end loop;
end;
/

  Was this answer useful?  Yes

ushodaya

  • May 20th, 2018
 

begin
for i in 1..10 loop
dbms_output.put_line(ushodaya);
end loop;
end;
/

  Was this answer useful?  Yes

manjunath

  • Sep 1st, 2018
 

Yesterday package execution took 10 mins today it takes 2 hours how to improve the package performance?

  Was this answer useful?  Yes

keerthi

  • Jan 4th, 2019
 

declare
i number;
begin
i:=1;
while(i<=10)
loop
dbms_output.put_line(keerthi);
i:=i+1;
end loop;
end;

  Was this answer useful?  Yes

Bibhudatta Panda

  • Jun 18th, 2019
 

Code
  1. BEGIN

  2. FOR i IN 1..10

  3. LOOP

  4. DBMS_OUTPUT.PUT_LINE(Raju);

  5. END LOOP;

  6. END;

  Was this answer useful?  Yes

Sri

  • Feb 7th, 2020
 

begin
i varchar2(10) :=xxxxxxx
begin
for x in 1..10 loop
dbms_output.put_line(i);
end loop;
end;
/

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions