Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Only get records that have been changed

Posted on 2011-03-17
Medium Priority
Last Modified: 2013-12-07
I am new to pl-sql and want to know how I would see if a record has been changed in pl-sql

Question by:running32
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35159139
Are you wanting the see the rows changed in pl/sql code versus say, sqlplus or some application?
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35159176
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.
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 35159791
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.

LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35160378
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
LVL 11

Expert Comment

ID: 35160944
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)
LVL 32

Accepted Solution

awking00 earned 2000 total points
ID: 35182969
You might try the attached.

Author Closing Comment

ID: 35183140

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to recover a database from a user managed backup

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question