Home » SQL & PL/SQL » SQL & PL/SQL » create a procedure
create a procedure [message #197603] Wed, 11 October 2006 23:36 Go to next message
oracle_coorgi
Messages: 185
Registered: September 2006
Location: INDIA-karnataka
Senior Member
hi
can one let me know how to create a procedure
which will serach the table if there is record update or else insert
thanxs

[Updated on: Thu, 12 October 2006 00:44]

Report message to a moderator

Re: create a procedure [message #197610 is a reply to message #197603] Thu, 12 October 2006 01:04 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
There is a SQL statement for that: MERGE.

MHE
Re: create a procedure [message #197662 is a reply to message #197603] Thu, 12 October 2006 03:58 Go to previous message
haikasi
Messages: 7
Registered: October 2006
Junior Member
we need to create a trigger that will fire whenever there is
a insert or update into a table that you want to monitor.which
will write logs to a user defined log file.

Then create a procedure that will read the contents from that
log file and show it to you, whenever you want to track changes.
Previous Topic: How to Create Database Tables from Excel Spreadsheets
Next Topic: Please help me out
Goto Forum:
  


Current Time: Mon Dec 05 04:33:33 CST 2016

Total time taken to generate the page: 0.08174 seconds