Recent content by oraprog

Thanks Dagon for replay

I mean, check start_date between START_PERIOD_DATE and END_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...

Tahnks a lot Dagon

then store in table test2 :: emp_no e_date serial_no p_no_amount_x p_no_amount_y p_no_amount_z p_no_amount_w ====== ====== ======= =========== ========= ========== ======== 1 2002-01-30 1 30 35 100 90...

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...

Thanks a lot Dagon. Thanks for your efforts,,,

THNKS A LOT , I need to dynamic code , no hard code , So that it works (trigger) when the repetition of the situation, insert into his (emp_no, start_date, end_date) values (rec.emp_no, store_his.hisUpd(i).end_date, to_date('2005-01-01', 'YYYY-MM-DD'));

Thanks a lot see store record: 2001-10-10 2005-01-01 ok when i insert new reocrd start_date & end_date nested between store record start_date & end_date :::>>> 2001-10-10 ( 2002-01-30 - 2003-09-01 ) 2005-01-01I Need to separate the dates and the distribution on record for same emp_no :::>>>...

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...

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...