Answer / Sonam Sidhu

To audit the SQL sent to the server, you can use tools such as SQL Audit or Database Activity Monitoring (DAM) solutions. These tools capture various types of database activities for security and compliance purposes.

What is the Difference between Procedure and Function.Can we call a Function in a DML?

2 Answers   TCS,

---

What is difference between pls_integer and integer?

1 Answers  

---

What are the features of pl sql?

1 Answers  

---

Authentication mechanisms in Sql Server ?

1 Answers   BirlaSoft,

---

How do you use collections in procedure to return the resultset?

1 Answers  

---

what is ref cursor in pl/sql?

3 Answers  

---

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

21 Answers   IBM,

---

explain advantages of innodb over myisam. : Sql dba

1 Answers  

---

What is the current version of postgresql?

0 Answers  

---

I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.

4 Answers   Cap Gemini, MTS,

---

what is the difference between stored procedure and packaged procedure

1 Answers   Google, Infosys,

---

what are the drivers in mysql? : Sql dba

1 Answers  

---