Answer / Smita Srivastava

The dbms_standard.sql_txt() and dbms_standard.sql_text() procedures are used to retrieve the text of a PL/SQL block or SQL statement that is currently being executed in the database. The difference between them is that sql_txt() returns the entire execution unit, including any declarative part (like variables, cursors, etc.), while sql_text() only returns the executable SQL statement. Both functions can be useful for debugging and understanding the exact SQL being executed by your application.

how can you process messages in order asynchronously?

1 Answers   Oracle,

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

1 Answers  

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1 Answers  

---

What is checkpoint?

3 Answers   Accenture,

---

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1 Answers  

---

What are the different ways of moving data or databases between servers and databases in SQL Server?

3 Answers  

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

1 Answers  

---

What would you do with an "in-doubt" distributed transaction?

1 Answers  

---

what is the difference between off-line back up and on-line back up in ibm db2 udb?

2 Answers   Zenith,

---

suppose you want to audit specific activities on sensitive data. How can you achieve that?

1 Answers   Oracle,

---

What types of replication are supported in sql server? : sql server DBA

1 Answers  

---

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,

---