What do the 9i dbms_standard.sql_txt() and
dbms_standard.sql_text() procedures do?
- 1 Answers
- 2497 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
