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 |
Is left join faster than inner join?
What is sql deadlock?
What is trigger and types?
Is pl sql a scripting language?
what is cursor. write example of it. What are the attributes of cursor.
What is a bitmap index?
4 Answers Choice Solutions, Infosys,
What are sql data types?
need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.
how to retrieve the top 3 salaries of the table using rownum
suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between 1 5 7.How can we do this using sql query??
What programs use sql?
what is row? : Sql dba