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,

---

What are the types of subqueries?

0 Answers  

---

Explain what is an index?

0 Answers  

---

Explain what is a view?

0 Answers  

---

Query for second maximum salary in each in each department

15 Answers   DST Global Solutions, TCS,

---

What is nested table in pl sql?

0 Answers  

---

<<labele>> declare a=10 b=20, begin some statements declare a=30 c=40 end; what is the A value in nested block?

1 Answers   ITC Infotech,

---

Write a sql query to convert all character to uppercase after hypen.

0 Answers  

---

HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP

1 Answers   TCS,

---

what are the 'mysql' command line arguments? : Sql dba

0 Answers  

---

what is julian date in oracle

2 Answers  

---

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

4 Answers   KPIT,

---