Home » SQL & PL/SQL » SQL & PL/SQL » Trigger on before delete
Trigger on before delete [message #628776] Fri, 28 November 2014 06:16 Go to next message
altaffdba
Messages: 7
Registered: November 2014
Location: hyderabad
Junior Member
Hi experts,
can anyone help to get the script for creating trigger---- before deleting data from a table, it should store data into another table.
Thanks
Re: Trigger on before delete [message #628781 is a reply to message #628776] Fri, 28 November 2014 07:10 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
This forum is not a free code-writing service but many will be glad to help you when you have a problem.

Show us what you have tried so far and explain what its not doing that you expect.
Re: Trigger on before delete [message #628792 is a reply to message #628781] Fri, 28 November 2014 08:27 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/


It is a challenge to write any SQL when you have no idea what tables or columns exist.
Re: Trigger on before delete [message #628810 is a reply to message #628792] Fri, 28 November 2014 09:20 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
@OP, what about giving a feedback about your previous topic http://www.orafaq.com/forum/m/627997/#msg_627997

[Updated on: Fri, 28 November 2014 09:22]

Report message to a moderator

Re: Trigger on before delete [message #628816 is a reply to message #628810] Fri, 28 November 2014 09:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

... yes, altaffdba , if you have not the tiny respect to answer our questions and feedback us, I don't see any reason to help you more.

Re: Trigger on before delete [message #628850 is a reply to message #628816] Sat, 29 November 2014 05:25 Go to previous messageGo to next message
altaffdba
Messages: 7
Registered: November 2014
Location: hyderabad
Junior Member
Hi all,
Sorry for not responding to previous topic. I dont have any reasons to explain it was my mistake. But u guys were helpfull.
Thanks
Re: Trigger on before delete [message #628851 is a reply to message #628850] Sat, 29 November 2014 05:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Your mistake can be helpful for others, so post what mistake it was.
Also you have posted a question we didn't answer, if you had the answer then post it too.
Forum is to be helpful for all who read it and not only for those who post questions.

Re: Trigger on before delete [message #628852 is a reply to message #628851] Sat, 29 November 2014 05:45 Go to previous messageGo to next message
altaffdba
Messages: 7
Registered: November 2014
Location: hyderabad
Junior Member
Yeah michel i will make sure from next time.
Thanks
Re: Trigger on before delete [message #628854 is a reply to message #628852] Sat, 29 November 2014 06:26 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

No, do it now, there is no reason your previous topic stays on hold waiting for you.

Previous Topic: Unable to execute private procedure at SQL prompt
Next Topic: Is there possible to update trigger table inside the same trigger
Goto Forum:
  


Current Time: Thu Mar 28 16:52:52 CDT 2024