Home » SQL & PL/SQL » SQL & PL/SQL » Trigger issue
Trigger issue [message #225440] Mon, 19 March 2007 23:35 Go to next message
subramanian.sp
Messages: 13
Registered: March 2007
Location: Pune
Junior Member
Can i create a trigger on view?
Re: Trigger issue [message #225444 is a reply to message #225440] Mon, 19 March 2007 23:45 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>Can i create a trigger on view?
I give up, can you?
What happened when you tried?
Re: Trigger issue [message #225462 is a reply to message #225440] Tue, 20 March 2007 00:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You can.

Regards
Michel
Re: Trigger issue [message #225476 is a reply to message #225462] Tue, 20 March 2007 01:09 Go to previous messageGo to next message
subramanian.sp
Messages: 13
Registered: March 2007
Location: Pune
Junior Member
But it's saying that "You cannot create trigger type on view" .
Please explain?
Re: Trigger issue [message #225490 is a reply to message #225476] Tue, 20 March 2007 01:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Who is saying that?
If you have an answer you trust, why asking the question?
Or why don't you trust my answer?
Please explain.
Re: Trigger issue [message #225504 is a reply to message #225476] Tue, 20 March 2007 03:20 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I think the problem is that you asked the wrong question.
Can you create a trigger on a view? Yes.
Can you create all the same triggers on a view that you can on a table? No.
Can you read up on Instead Of triggers? That remains to be seen.

On a more serious note, go back and read your posts - do you feel that you could have put a bit more effort into them, and perhaps given us some information to work with?

If you'd said "I've got a view V_View, and I'm trying to create a trigger to fire when I insert/update/delete rows into it. Here is my trigger code <code> but it doesn't work, and gives me the following error <error>" then you'd have had an accurate and concise answer pretty quickly.

All you chose to say was "But it's saying that 'You cannot create trigger type on view'. Please explain? ", so you'll have to forgive us for matching your own level of activity and just pointing you at the Docs
Re: Trigger issue [message #225508 is a reply to message #225490] Tue, 20 March 2007 03:25 Go to previous messageGo to next message
subramanian.sp
Messages: 13
Registered: March 2007
Location: Pune
Junior Member
Hello,

First understand onething .This Board is for discussion only and not to fight.I have tried to create to a trigger on view but it's saying that "Cannot create trigger on views" ,but i dont know the reason,that's why i have posted the question and not to show am genious.Even you can try and then post your reply.ok.
Re: Trigger issue [message #225512 is a reply to message #225504] Tue, 20 March 2007 03:34 Go to previous messageGo to next message
subramanian.sp
Messages: 13
Registered: March 2007
Location: Pune
Junior Member
Thanx
Re: Trigger issue [message #225523 is a reply to message #225508] Tue, 20 March 2007 03:58 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You do need to ask yourself if this sort of attitude is really advisable. After all, you've come here asking people to spend their free time helping you. Telling them how they may and may not behave is just arrogant in that situation.
Previous Topic: INSERT UPDATE trigger HELP
Next Topic: help with ...
Goto Forum:
  


Current Time: Sat Dec 03 22:11:10 CST 2016

Total time taken to generate the page: 0.11817 seconds