What are the ways on commenting in a pl/sql code?

0 Answers  

---

What are the various levels of constraints?

0 Answers  

---

How can we make an if statement within a select statement?

0 Answers  

---

need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

2 Answers  

---

What is record data type?

0 Answers  

---

---

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop

4 Answers   JDA,

---

What is rank dense_rank and partition in sql?

0 Answers  

---

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 

2 Answers   GE,

---

What is replication id?

0 Answers  

---

What is sqlite used for?

0 Answers  

---

What is benefit of creating memory optimized table?

0 Answers  

---

How does one use sql*loader to load images, sound clips and documents? : aql loader

0 Answers  

---