Answer / gogu s k

For security and audit related events and to record changes
done to database, triggers are best.

For applying business rules and performing dml operations
procedures are ideal.

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  

---

What is dynamic query?

0 Answers  

---

What is an index and types of indexes. How many number of indexes can be used per table ?

12 Answers   Accenture, BirlaSoft, Cognizant, CTS, Symphony,

---

What is constant in pl sql?

0 Answers  

---

what is sql and plsql

6 Answers  

---

how to show all tables with 'mysql'? : Sql dba

0 Answers  

---

What does seeding a database mean?

0 Answers  

---

what is the difference between delete and truncate commands? : Sql dba

0 Answers  

---

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop

4 Answers   JDA,

---

how u can find the n row from a table?

19 Answers   Tech Mahindra,

---

A table has 150 records. How do you retrieve 100th row to 120th row from that table ?

21 Answers   IBM,

---

what is 'mysqlcheck'? : Sql dba

0 Answers  

---