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 ?
- 3 Answers
- 7777 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / kotesh
result is 11111
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is basic structure of pl sql?
How would you convert date into julian date format?
What is indexes?
What is embedded sql what are its advantages?
How can you tell the difference between an index and a view?
What are % type and % rowtype?
What is pivot query?
How delete all data from all tables in sql?
Why having clause is used in sql?
What is query execution plan in sql?
Will truncate release space?
What is error ora-01000: maximum open cursors exceeded
Explain the difference between drop and truncate commands in sql?
Can you sum a count in sql?
What is a sql select statement?
