Can we use loop in sql?

0 Answers  

---

How to download oracle sql developer?

0 Answers  

---

How do we tune the code?

2 Answers  

---

How can I pass the inner procedure value to outer procedure ?

2 Answers  

---

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 is 'force view'?

3 Answers   Cap Gemini, SPIC,

---

What is a boolean in sql?

0 Answers  

---

mail-id table contains two columns(email_id,userid) it contains different types of mail-ids,and no of users. here username length is differ na,(ex- tamil@yahoo.com,joshua@hotmail.com like) now i want to fetch the email-ids only starting from '@' (ex-@gmail.com,@yahoo.com,@hotmail.com

5 Answers  

---

How to look at the current sql*plus system settings?

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

---

Are sql views compiled?

1 Answers  

---

What is sql used for?

0 Answers  

---