Home » SQL & PL/SQL » SQL & PL/SQL » How to Stop insertion of specific transactions in a table in ORACLE
How to Stop insertion of specific transactions in a table in ORACLE [message #341721] Wed, 20 August 2008 01:55 Go to next message
m_hammad
Messages: 1
Registered: August 2008
Junior Member
I want to stop insertion of transactions in a table that have two columns "transaction number" and "transaction date". Transactions of "AUG-2008" should not be inserted in the table. Is it possible by database trigger. If yes then how?

please reply urgently.
Re: How to Stop insertion of specific transactions in a table in ORACLE [message #341726 is a reply to message #341721] Wed, 20 August 2008 02:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to be more precise on what you want to do.
You insert from what? a table, a file, a set of "insert values" statements?
You want to stop at the first error or you want to execute all statements but the offending ones?
Oracle version with 4 decimals?
And so on.

Regards
Michel
Re: How to Stop insertion of specific transactions in a table in ORACLE [message #341729 is a reply to message #341721] Wed, 20 August 2008 02:18 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
urgently



Just kidding.
Don't do that. Everybody wants an answer NOW, so there is no point in emphasizing that.

We at OraFAQ do not believe in handing out ready-made solutions. We like to help people to get to the solution themselves, so they learn in the process of getting there.
In order to help you, you have to show us what you tried and where you got stuck.
Previous Topic: carriage return and semi colon in a quoted string
Next Topic: Storing Chinese Character
Goto Forum:
  


Current Time: Sat Dec 10 16:33:55 CST 2016

Total time taken to generate the page: 0.09390 seconds