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,

---

Is it possible to read/write files to-and-from PL/SQL?

0 Answers  

---

What are the different types of joins in sql?

0 Answers  

---

Can a table contain multiple primary key’s?

0 Answers  

---

What is a schema sql?

0 Answers  

---

---

have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.

8 Answers   IBM, Zensar,

---

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

0 Answers  

---

How to display the records between two range in Oracle SQL Plus?

0 Answers   MCN Solutions,

---

What is the use of cursor ? how cursor allocate context area for executing the sql statement?

4 Answers   HCL,

---

How can I see all tables in sql?

0 Answers  

---

What is the order of sql select?

0 Answers  

---

List different type of expressions with the example.

0 Answers  

---