Are stored procedures faster than dynamic sql?

0 Answers  

---

What are the different schemas objects that can be created using pl/sql?

0 Answers  

---

I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.

1 Answers   IBM, Saama Tech,

---

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  

---

define primary key & secondary key?

2 Answers  

---

what is the difference between the query and corelated query

8 Answers   HSBC, IBM, TCS, Xenosoft,

---

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

0 Answers   MCN Solutions,

---

What are the parts of a basic sql query?

0 Answers  

---

What is the mutating table and constraining table?

0 Answers  

---

How does left join work in sql?

0 Answers  

---

define different types of trigger. : Sql dba

1 Answers  

---

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

0 Answers  

---