trigger

Discussion List

• 
  Unified Audit Trail logs mirror table

  Solution Accepted User_MDUQ4 62 views 13 comments 0 points Most recent by Solomon Yakobson Jan 9, 2023 1:23PMSQL & PL/SQL
• 
  Difference Between Mutating Trigger and Mutating Table

  Solution Accepted Bommi 134 views 12 comments 0 points Most recent by Bommi Dec 12, 2022 5:57AMSQL & PL/SQL
• 
  CREATED TRIGGER WHEN A PARTICULAR COLUMN OF A TABLE IS UPDATED but the below is throwing error

  Question User_VG86W 11 views 0 comments 0 points Started by User_VG86W Nov 29, 2022 2:34PM MySQL Community Space
• 
  I can't use EXECUTE IMMEDIATE with trigger

  Responded But No Solution User_I695Q 59 views 5 comments 0 points Most recent by BEDE Nov 16, 2022 11:08AMSQL & PL/SQL
• 
  Pre insert trigger to prepopulate field with certain value only for certain users

  Responded But No Solution GlenStrom 31 views 1 comment 0 points Most recent by Paulzip Nov 9, 2022 6:45PMSQL & PL/SQL
• 
  How to avoid Table mutating

  Question User_JFC05 11 views 0 comments 0 points Started by User_JFC05 Nov 9, 2022 5:29PM JavaServer Pages (JSP) and JSTL
• 
  When i try to create trigger , i am geting below error. kindly tell me how to fix this?

  Responded But No Solution User_HE7VI 51 views 4 comments 0 points Most recent by mathguy Nov 5, 2022 1:03AMSQL & PL/SQL
• 
  Need to copy deleted row into Table-2 from Table-1 when a row is deleted from Table-1

  Solution Accepted Harikrishnan 32 views 3 comments 0 points Most recent by Harikrishnan Sep 19, 2022 5:55AMSQL & PL/SQL
• 
  Oracle PL/SQL: Trigger Syntax

  Responded But No Solution User_TUDYU 254 views 29 comments 0 points Most recent by L. Fernigrini Sep 16, 2022 3:06PMSQL & PL/SQL
• 
  Associate array in compound Triggers

  Solution Accepted User_W38VZ 41 views 4 comments 0 points Most recent by Frank Kulash Sep 15, 2022 7:11PMSQL & PL/SQL
• 
  How to check user logon latency when a logon trigger is enabled ?

  Question User_N022N 1 view 0 comments 0 points Started by User_N022N Aug 30, 2022 4:07PM General Database Discussions
• 
  How to use insert with update?

  Responded But No Solution User_2TTDA 32 views 2 comments 0 points Most recent by Frank Kulash Jul 31, 2022 3:08AMSQL & PL/SQL
• 
  4

  Up Down
  Disable trigger at a session level

  Active User_S1J6P 39 views 2 comments 4 points Most recent by Rainer Stenzel Jul 20, 2022 4:37PMGeneral Database Discussions - Ideas
• 
  Create a trigger to apply the new profile

  Solution Accepted User_JZ5OJ 138 views 10 comments 0 points Most recent by User_JZ5OJ Jun 24, 2022 3:01PMSQL & PL/SQL
• 
  Triggers with count(*)

  Responded But No Solution Havva 31 views 2 comments 0 points Most recent by Havva Apr 18, 2022 8:49PMAPEX Discussions
• 
  QUERY FOR EVENT TRIGGER

  Responded But No Solution Krishna_Vellela525 11 views 1 comment 0 points Most recent by Suresh Sangaran-Oracle Mar 2, 2022 5:38AMReports
• 
  Query from trigger not showing up in Monitor Sessions

  1N82 11 views 1 comment 0 points Most recent by thatJeffSmith-Oracle Feb 10, 2022 6:08PMSQL Developer
• 
  Oracle 21c: select permission on v_$session

  Solution Accepted User_KC6Y3 68 views 3 comments 0 points Most recent by User_H3J7U Jan 10, 2022 8:16PMGeneral Database Discussions
• 
  ORA-25000: invalid use of bind variable in trigger WHEN clause

  Solution Accepted amjadham77Q 343 views 3 comments 0 points Most recent by amjadham77Q Nov 26, 2021 9:35PMSQL & PL/SQL
• 
  How can I prevent my update from modifying all the columns?

  Solution Accepted Edisson Gabriel López 53 views 1 comment 0 points Most recent by Anton Scheffer Nov 26, 2021 3:13PMSQL & PL/SQL
• 
  How can I insert into a table after an insert event?

  Responded But No Solution Edisson Gabriel López 21 views 2 comments 0 points Most recent by L. Fernigrini Nov 26, 2021 11:05AMSQL Developer
• 
  How can I insert into a table after an insert event?

  Solution Accepted Edisson Gabriel López 260 views 3 comments 0 points Most recent by Frank Kulash Nov 25, 2021 10:39PMSQL & PL/SQL
• 
  ALTER TABLE DISABLE ALL TRIGGERS not working on editioned view in R12.2.9

  Question AbhishekS 22 views 0 comments 0 points Started by AbhishekS Oct 19, 2021 2:54PM General Database Discussions