How would you reference column values before and after you have inserted and deleted triggers?

0 Answers  

---

What is the difference between nested table and varray?

0 Answers  

---

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

1 Answers  

---

What is the difference between syntax error and runtime error?

0 Answers  

---

what is a constraint? Tell me about its various levels. : Sql dba

0 Answers  

---

---

ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.

2 Answers  

---

Write a simple program on cursors

2 Answers   BirlaSoft,

---

what are wild cards used in database for pattern matching ? : Sql dba

0 Answers  

---

Begin For j in 4403201000 .. 4403202000 Loop If mod (j, 100) = 0 then Dbms_output.put_line (j); End if; End loop; End; what will be the output of this question

7 Answers   TCS,

---

What is scalar and vector?

0 Answers  

---

Delete the emps whose salaries are lowest sals of their own dept.

5 Answers  

---

Give the structure of the function ?

2 Answers  

---