OraFAQ Forum: SQL & PL/SQL » How to avoid trigger

Home » SQL & PL/SQL » SQL & PL/SQL » How to avoid trigger

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to avoid trigger [message #613234]

Thu, 01 May 2014 07:29

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

Hi Guys,

Please explain here, how to avoid trigger.

Report message to a moderator

Re: How to avoid trigger [message #613235 is a reply to message #613234]

Thu, 01 May 2014 07:33

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

sqlplus / as sysdba

Wink

Report message to a moderator

Re: How to avoid trigger [message #613236 is a reply to message #613234]

Thu, 01 May 2014 07:42

dr.s.raghunathan
Messages: 540
Registered: February 2008

Senior Member

disable it

Report message to a moderator

Re: How to avoid trigger [message #613237 is a reply to message #613234]

Thu, 01 May 2014 07:53

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

aaditya321 wrote on Thu, 01 May 2014 17:59

how to avoid trigger.

What is the issue you are facing? Do you see any side effect caused(usually they are nothing but a side effect of an operation). Be specific about your question. Else the best way to avoid it is to stop being concerned about it.

Report message to a moderator

Re: How to avoid trigger [message #613238 is a reply to message #613234]

Thu, 01 May 2014 08:06

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Don't hit the condition that "triggers" it. QED.

Report message to a moderator

Re: How to avoid trigger [message #613240 is a reply to message #613234]

Thu, 01 May 2014 08:51

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

And now are you satisfy by the answers in your previous topic, you didn't tell us?

http://www.orafaq.com/forum/m/613072/#msg_613072

Report message to a moderator

Re: How to avoid trigger [message #613268 is a reply to message #613237]

Fri, 02 May 2014 00:25

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

Lalit Kumar B wrote on Thu, 01 May 2014 07:53

aaditya321 wrote on Thu, 01 May 2014 17:59
how to avoid trigger.

What is the issue you are facing? Do you see any side effect caused(usually they are nothing but a side effect of an operation). Be specific about your question. Else the best way to avoid it is to stop being concerned about it.

I am facing performance issue so I want to use some others which that work instead of trigger.

Report message to a moderator

Re: How to avoid trigger [message #613270 is a reply to message #613268]

Fri, 02 May 2014 00:27

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

So either you don't need what the trigger does and tehn drop the trigger.
Either you need what the trigger does and you can't avoid to pay for it anyway.

[Updated on: Fri, 02 May 2014 00:27]

Report message to a moderator

Re: How to avoid trigger [message #613271 is a reply to message #613270]

Fri, 02 May 2014 05:32

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

Thank you Michel for solving my confusion.

Report message to a moderator

Previous Topic:	need function convert time digit to analog
Next Topic:	Why we cannot use procedure in select statement?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 18:38:26 CDT 2024