Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: oraprog
  • Content: Threads
  • Order by date
  1. oraprog

    How to calculate period date

    Following is the scenario: CREATE TABLE EMP_VACATION( EMP_NO NUMBER(3), VAC_TYPE NUMBER(1), START_DATE DATE, END_DATE DATE, START_PERIOD_DATE DATE, END_PERIOD_DATE DATE, PRIMARY KEY (EMP_NO,VAC_TYPE,START_DATE)) INSERT VALUES EMP_VACATION(EMP_NO,VAC_TYPE,START_DATE,END_DATE) VALUES(1, 1...
  2. oraprog

    Help , how to transfer data and processing

    Following is the scenario: create table test1 ( emp_no number, p_no varchar2(2), p_amount number(10), ) insert into test1 values (1, 'x', 10 ); insert into test1 values (1, 'x', 20 ); insert into test1 values (1, 'y', 35 ); insert into test1 values (1, 'z', 60 ); insert into test1...
  3. oraprog

    ora-04091,ORA-06512,ORA-04088 mutating ?

    assuming one record store in the table HST, create table(emp_no,start_date,end_date) primary_key(emp_no,start_date) ---------------------------------------:::: emp_no start_date end_date ------- ---------- ---------- 10 2001-10-10 2005-01-01...
  4. oraprog

    ora-04091,ORA-06512,ORA-04088 mutating ?

    I create this trigger: CREATE OR REPLACE TRIGGER T_HST AFTER INSERT On HST FOR EACH ROW DECLARE Begin INSERT INTO HST (EMP_NO, START_DATE ) SELECT EMP_NO, SYSDATE FROM HST WHERE EMP_NO = :NEW.EMP_NO; End T_HRS_SAL_PERIOD_HSTY_UPD_PRI; / when I insert a new...

Part and Inventory Search

Back
Top