Answer Posted / 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

If a cursor is open, how can we find in a pl/sql block?

1252

---

Do we need to rebuild index after truncate?

1151

---

what are the advantages of sql ? : Sql dba

1153

---

Can we use distinct and group by together?

1146

---

Is primary key always clustered index?

1101

---

What is your daily office routine?

2351

---

what is bcp? When does it used? : Sql dba

1065

---

Can we rollback truncate?

1083

---

what are all the common sql function? : Sql dba

1141

---

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

1125

---

how to escape special characters in sql statements? : Sql dba

1124

---

Is inner join faster than left join?

1287

---

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

1154

---

what is collation? : Sql dba

1242

---

Does group by remove duplicates?

1120

---