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   Oracle,

---

can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)

5 Answers  

---

What are the benefits of triggers?

0 Answers  

---

what is the difference between char and varchar data types? : Sql dba

0 Answers  

---

What is the most restrictive isolation level? : Transact sql

0 Answers  

---

Do view contain data?

6 Answers   Ramco,

---

What is a Mapplet?

0 Answers   Informatica,

---

What does <> sql mean?

0 Answers  

---

write a query find which rows of a table is updated on 2 days before?

3 Answers   TCS,

---

Types of locks in database ?

8 Answers   HCL, TCS, Tieto,

---

What is normalization? dec 2009

3 Answers   Cognizant,

---

What is the difference between execution of triggers and stored procedures?

0 Answers  

---