Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 408
  • Last Modified:

Only get records that have been changed

I am new to pl-sql and want to know how I would see if a record has been changed in pl-sql

thanks
0
running32
Asked:
running32
  • 3
  • 2
  • 2
  • +1
1 Solution
 
slightwv (䄆 Netminder) Commented:
Are you wanting the see the rows changed in pl/sql code versus say, sqlplus or some application?
0
 
slightwv (䄆 Netminder) Commented:
The rowcount post brings up an interesting question:  I read the question to mean 'after some time' not 'while the code is running'.

Please clarify.
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
running32Author Commented:
slightwv, you are correct in the evening I want to see if there has been a change in a record and only select the records that have been changed.

Thanks
0
 
slightwv (䄆 Netminder) Commented:
You are describing auditing.  Oracle has several audit methods depending on your specific requirements and how your applications are designed.

I suggest you chek out the online docs.  They will talk about the various options.

I'm online right now and can't provide the exact links but the docs are online at www.oracle.com
0
 
AkenathonCommented:
You can either manually record the operations with your custom PL/SQL code using triggers, or else let the DB do the work by using DBMS_FGA (Fine-Grained Auditing)
0
 
awking00Commented:
You might try the attached.
query.txt
0
 
running32Author Commented:
Thanks
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now