What is cte?

0 Answers  

---

i have a word ***********hello********world******. I require a o/p **********hello world**********, Need to delete the middle stars.

3 Answers  

---

what is not null constraint? : Sql dba

0 Answers  

---

What will happen after commit statement ?

2 Answers  

---

Can we use update in sql function?

0 Answers  

---

select sal from emp group by sal

3 Answers   TCS,

---

State the advatage and disadvantage of Cursor's?

2 Answers  

---

What is minus?

0 Answers  

---

What's the procedure?

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  

---

Write one update command to update seqno field of a table on the basis of row number.

4 Answers   HCL,

---

what is the order of pre-defined exceptions.

6 Answers   TCS,

---