What are data types in pl sql?

0 Answers  

---

What is sql key?

0 Answers  

---

Can one improve the performance of sql*loader? : aql loader

0 Answers  

---

What is the usage of nvl function?

0 Answers  

---

What is sql profiler in oracle?

0 Answers  

---

Why primary key is required?

0 Answers  

---

What is the location of pre_defined_functions.

0 Answers  

---

What is a system versioned table?

0 Answers  

---

Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.

3 Answers   JPMorgan Chase,

---

What are inner and outer joins examples of both?

0 Answers  

---

table :- city name country code abc 11 bcd 22 cde 232 def 33 write a procedure , so that when we give a phone no. eg - 1123456789 - o/p sud be city name = abc if phone no. - 2322345897 , o/p sud be =cde note - bcd and cde city name sud be diff. as dey diff only with th last no. Pls ans. this questnion.

1 Answers  

---

Which one of the following join types will always create a Cartesian Product? 1. CROSS JOIN 2. LEFT OUTER JOIN 3. RIGHT OUTER JOIN 4. FULL OUTER JOIN 5. INNER JOIN

2 Answers  

---