1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

declare
lowerl number:= 1;
upperl number:= 3;
num varchar2(10);
begin
for i into lowerl..upperl
loop
num:=num||to_char(lowerl);
if i=3 then upperl:=5;
end loop;
message(num);
What will be the output ?

Question Posted / guest

Answers were Sorted based on User's Feedback



declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into l..

Answer / anil kumar jampana

declare
lowerl number:= 1;
upperl number:= 3;
num varchar2(10);
begin
for i in lowerl..upperl
loop
num:=num||to_char(lowerl);
if i=3 then upperl:=5;
end if;
end loop;
message(num);
end;
some changes in the programme.......
it will result 111

Is This Answer Correct ?    13 Yes 0 No

declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into l..

Answer / guest

result will be 111

Is This Answer Correct ?    6 Yes 0 No

declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into l..

Answer / kotesh

result is 11111

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More SQL PLSQL Interview Questions

how to calculate the difference between two dates? : Sql dba

0 Answers  

what is self join and why is it required? : Sql dba

1 Answers  

can i use global variables in stored procedure or function

1 Answers   L&T,

what is oltp (online transaction processing)? : Sql dba

0 Answers  

What is the difference between numeric and autonumber?

0 Answers  




What is equi join in sql?

0 Answers  

What are system versioned tables?

0 Answers  

how to find the second highest salary from emp table?

211 Answers   CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar,

What is a common use of group by in sql?

0 Answers  

How many scalar data types are supported in pl/sql?

0 Answers  

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?

9 Answers   TCS,

what are the 'mysql' command line arguments? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories