result is 11111

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 / kotesh

3 Answers
8888 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

Please Help Members By Posting Answers For Below Questions

What is application trigger?

977

What is a rank in sql?

940

what is a table in a database ? : Sql dba

1024

Can we use distinct and group by together?

1025

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1818

How to know the last executed procedure?

1071

How do I write a sql query in pgadmin 4?

962

what is the use of double ampersand (&&) in sql queries?

1157

what is myisam? : Sql dba

1055

What is a null value?

1125

What is a clob in sql?

1002

What is the difference between the conventional and direct path loader? : aql loader

1142

which types of join is used in sql widely? : Sql dba

968

What is serial sql?

956

When is a declare statement required?

1128