1
  • Calculate time difference with Oracle 9i

    I want to calculate difference between current time and time which is stored in table. How will I calculate the difference between 2 time? After calculating this difference, if this difference is greater than 3 hrs my system should generate an email to technical head. How do I do this? Shall I go...

    Firasha25 pointsBadges:
  • How to call trigger stored in database using Oracle Forms

    how to call trigger stored in database using oracle forms

    RoseForHeba5 pointsBadges:
  • How can I write a trigger that fires everyday at night 9’o clock?

    Actually I'm developing a project I want to write a trigger that should fire every day at night 9'o clock and that trigger should copy data from one table to another table.

    gowthamgk85 pointsBadges:
  • Conversion of Oracle trigger to MS SQL

    How can I convert an Oracle trigger into MS-SQL?

    Jannat895 pointsBadges:
  • 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?

    VelameLaCosa110 pointsBadges:
  • Can I achieve auto-increment in Oracle without using triggers?

    Is there a way to achieve auto-increment in Oracle rather than using triggers? I'm working on a project and triggers won't work for me.

    ITKE413,650 pointsBadges:
  • 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.

    Sarah1234520 pointsBadges:
  • 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)...

    RizwanSharief30 pointsBadges:
  • 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 other...

    Pmnc81795 pointsBadges:
  • 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 (...

    APB10 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following