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 ?
Answers were Sorted based on User's Feedback
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 |
how to calculate the difference between two dates? : Sql dba
what is self join and why is it required? : Sql dba
can i use global variables in stored procedure or function
what is oltp (online transaction processing)? : Sql dba
What is the difference between numeric and autonumber?
What is equi join in sql?
What are system versioned tables?
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?
How many scalar data types are supported in pl/sql?
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?
what are the 'mysql' command line arguments? : Sql dba