How do you exit in sql?

0 Answers  

---

What are two statement types in sql?

0 Answers  

---

What are the disadvantages of not performing database normalization?

0 Answers  

---

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

0 Answers  

---

How do you pronounce sql?

0 Answers  

---

How will you distinguish a global variable with a local variable in pl/sql?

0 Answers  

---

Let us suppose we have a table with structure in order empno empname empdesig empcountry and now i want to re-organize the columns of this table to empno empdesig empname empcountry how can i do this with queries ? assume that table contains the data.

3 Answers  

---

What are indexes, and what are the different types?

3 Answers  

---

What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

2 Answers   JDA,

---

what is Difference between Having and Where clause?

5 Answers   IBM,

---

What is sqlerrd?

0 Answers  

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

0 Answers  

---