adspace


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

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 the best sql course?

1063

Is primary key clustered index?

1027

Can delete statement be rollbacked?

1065

what is sql server agent? : Sql dba

1188

what are aggregate and scalar functions? : Sql dba

1142

how to use regular expression in pattern match conditions? : Sql dba

1125

How do I remove duplicates in two columns?

1202

what are the advantages of sql ? : Sql dba

1154

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2100

Can we use distinct and group by together?

1146

Is primary key always clustered index?

1101

Does group by remove duplicates?

1120

what is dbms? : Sql dba

1070

What is the current version of sql?

1106

how many tables will create when we create table, what are they? : Sql dba

1155