What is sql profiling in oracle?

0 Answers  

---

What are the subsets of sql?

0 Answers  

---

Is sql procedural language?

0 Answers  

---

What is a nested table in word?

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  

---

how to get @@error and @@rowcount at the same time? : Sql dba

0 Answers  

---

How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?

2 Answers   Fidelity,

---

can we delete the trigger in a view? if yes why if not why?

5 Answers   Tech Mahindra,

---

How do I save the results of sql query in a file?

0 Answers  

---

how to use myisamchk to check or repair myisam tables? : Sql dba

0 Answers  

---

select 1,col1,col2 from table1. output?

5 Answers   Ramco,

---

What if we write return in procedure?

0 Answers  

---