How to prepare for oracle pl sql certification?

0 Answers  

---

Which is faster subquery or join?

0 Answers  

---

write the Sql query for creating database backup?

7 Answers   TCS,

---

How many scalar data types are supported in pl/sql?

0 Answers  

---

in procedure how to return a value

3 Answers   Wipro,

---

---

what are the advantages of package?

7 Answers   iFlex,

---

How do sql databases work?

0 Answers  

---

Can we use views in stored procedure?

0 Answers  

---

1.when will you use week refcursor and when will you use strong ref cursor ? 2.what is the use of sql trace..how do you use it ? 3.can you please send all the sql plus commands...like set line 6000....

1 Answers   Satyam,

---

What are the different datatypes available in PL/SQL?

0 Answers  

---

Is it possible to include an insert statement on the same table to which the trigger is assigned?

0 Answers  

---

Difference between NVL, NVL2 and NULLIF

1 Answers   CTS, Metric Stream,

---