how can i convert an oracle trigger into MS-SQL?
Answer Question | October 12, 2011 1:49 PM
MSSQL, Oracle triggers, SQL connectivity, SQL Server
Hello, im going to create a trigger(insert or update) for a tableA, when it fires inserted or updated columns are should be insert or update into another table say tableB, one column(Processed_time) in tableB where its value will be by subtrcting two columns in tableA(response_time,Submission_time) all are timestamp type how to update(Processed_time) in tableB by [...]
Answer Question | July 1, 2010 11:46 AM
Oracle PL/SQL, Oracle SQL Developer, Oracle triggers, SQL Trigger
when-validate-item trigger not forong as soon as the item is changed. I have set validate-from-list property of item to be yes buit still when I press any other buttonm on the form this trigger is raised. Please help me out in this regard.
Answer Question | June 12, 2012 5:10 AM
Oracle Forms, Oracle Forms 6i, Oracle triggers
1)i wanna calculate difference between current time and time which is stored in table. how will i calculate the difference between 2 time?? 2) after calculating this difference ,if this difference is greater than 3 hrs my system should genrate an email to technical head. how do i do this?shall i go for any trigger?if [...]
Answer Question | February 29, 2012 11:50 AM
Oracle 9i, Oracle development, Oracle Forms 6i, Oracle triggers
Is it possible to create a trigger on table A if there is an insert, update, or delete then fire the trigger but in addition to the changes in table A I want to capture values from table B,C,D,E…. even if those records had no action applied to them. I tried declaring variables from the [...]
Answer Question | July 30, 2009 3:48 PM
LEFT OUTER JOIN statement, Oracle, Oracle triggers, Triggers
I’ve been given an Oracle DB that has some triggers and “LOAD DATA” jobs. Is there a tool/utility to convert the triggers/loads from PL/SQL into T-SQL?
Answer Question | June 23, 2011 9:20 PM
Database conversion, Oracle import/export, Oracle triggers, PL/SQL, SQL, T-SQL
CREATE OR REPLACE PACKAGE trigger_api AS PROCEDURE tab1_row_change (p_id IN ae_dt526.field1%TYPE, p_action IN varchar2, p_field13 IN varchar2, p_blanket_ind IN varchar2 ); PROCEDURE tab1_statement_change; END trigger_api; / CREATE OR REPLACE PACKAGE BODY trigger_api AS TYPE t_change_rec is record ( field1 ae_dt526.field1%TYPE, action tab1_audit.action%TYPE, field13 tab1_audit.field13%TYPE, blanket_ind tab1_audit.blanket_ind%TYPE ); TYPE t_change_tab is table of t_change_rec; g_change_tab t_change_tab [...]
Answer Question | February 2, 2009 11:39 PM
ORA-06533, Oracle 10g, Oracle 10g triggers, Oracle triggers, Subscript beyond count, Triggers
how to call trigger stored in database using oracle forms
Answer Question | November 12, 2011 9:47 AM
Oracle development, Oracle Forms, Oracle triggers, Triggers