Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.8K Databases
- 221.5K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.8K SQL & PL/SQL
- 21.2K SQL Developer
- 295.3K Development
- 17 Developer Projects
- 138 Programming Languages
- 292K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 27 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 390 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1K Español
- 1.9K Japanese
- 230 Portuguese
Procedure or function to create insert scripts on table
3574779
Member Posts: 16
Hi,
I have a requirment to monitor dml statements on few tables and gather the scripts.we have dba audit table but we are not getting required data some times
Can we write a procedure to genrate insert script on tables passed as parameter.
Later can we use that procedure in dml trigger to generate the script values and store in a table as clob value.please give ur suggestions
Tagged:
Answers
-
3574779 wrote:Hi,I have a requirment to monitor dml statements on few tables and gather the scripts.we have dba audit table but we are not getting required data some times
What required data is missing?
Can we write a procedure to genrate insert script on tables passed as parameter.
I give up.
Can you?
Later can we use that procedure in dml trigger to generate the script values and store in a table as clob value.please give ur suggestions
Your specific requirements are unclear
Please read the content of URL below & respond accordingly.
How do I ask a question on the forums?
Why are NONE of your threads marked as ANSWERED?