conversion of oracle trigger to MS SQL
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

ORACLE-TRIGGERS
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

Oracle Forms 6i when-validate-item trigger not firing
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

Calculate time difference with Oracle 9i
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

After trigger select from other tables using joins
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

Convert Oracle code to Microsoft SQL code
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

Subscript beyond count on nested table (trying to update a column in a trigger for the same table as trigger)
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
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