Home » SQL & PL/SQL » SQL & PL/SQL » can we create a trigger on one column
can we create a trigger on one column [message #251675] Mon, 16 July 2007 01:15 Go to next message
msafana
Messages: 31
Registered: July 2007
Member
can we create a trigger on one column
Re: can we create a trigger on one column [message #251678 is a reply to message #251675] Mon, 16 July 2007 01:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe, what is the problem you're trying to solve or the goal you're trying to achieve? What is the business need?
What is your Oracle version (4 decimals)?

Regards
Michel
Re: can we create a trigger on one column [message #251681 is a reply to message #251675] Mon, 16 July 2007 01:18 Go to previous messageGo to next message
ammishra
Messages: 179
Registered: January 2007
Location: india
Senior Member
Wait some time Michel will give you link. Laughing
Re: can we create a trigger on one column [message #251686 is a reply to message #251678] Mon, 16 July 2007 01:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Answer depends on the question/problem.
Ask them to precise the question and above what is the need they want to fit.

Regards
Michel
Re: can we create a trigger on one column [message #251726 is a reply to message #251686] Mon, 16 July 2007 04:52 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
For insert or delete, as that are row operations, it does not make sense to create a trigger on a column. You have the WHEN clause to add extra conditions.

For update there is the option to say for what columns the trigger will fire. But you can look it up in the SQL reference.

MHE
Re: can we create a trigger on one column [message #251807 is a reply to message #251678] Mon, 16 July 2007 13:13 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
msafana wrote on Mon, 16 July 2007 08:30
hi,
I dont know the perfect meaning.I got this question from others.Just i want to know the answer.
Thanks for ur reply.

Sorry, but I am stunned by this.
You are asked to do something and instead of telling them you don't exactly understand what they mean, you just keep quiet and ask it here.
I have only one word for this (well, only one I can say here, that is):

WHY?
Previous Topic: error 00920 ??
Next Topic: performance problems
Goto Forum:
  


Current Time: Sat Dec 10 22:31:49 CST 2016

Total time taken to generate the page: 0.13265 seconds