i have a table with 9 fields and 2 fileld primary key(num_group_code,dt_change)
(1):-first time data insert
(2):second time I edit then same primary key on value second row in insert ,and with dt_effect_F to this value change to dt_effect_T in first row and isValid change 1 to 0
and second row isValid 1.
CREATE TABLE AMIT.UMS_MST_GROUP
(
NUM_GROUP_CODE NUMBER(2) primary key NOT NULL,
STR_GROUP_NAME VARCHAR2(20 BYTE) NOT NULL,
NUM_DESIG_CODE NUMBER(3) NOT NULL,
DT_EFFECT_F DATE NOT NULL,
DT_EFFECT_T DATE,
IS_VALID NUMBER(1) DEFAULT 1 NOT NULL,
NUM_CHANGEDBY NUMBER(5) NOT NULL,
DT_CHANGE DATE primary key DEFAULT sysdate NOT NULL,
IS_LOCK NUMBER(1) DEFAULT 0 NOT NULL
)
hibernate and strutsrajesh kumar August 8, 2012 at 11:54 AM
i have a table with 9 fields and 2 fileld primary key(num_group_code,dt_change) (1):-first time data insert (2):second time I edit then same primary key on value second row in insert ,and with dt_effect_F to this value change to dt_effect_T in first row and isValid change 1 to 0 and second row isValid 1. CREATE TABLE AMIT.UMS_MST_GROUP ( NUM_GROUP_CODE NUMBER(2) primary key NOT NULL, STR_GROUP_NAME VARCHAR2(20 BYTE) NOT NULL, NUM_DESIG_CODE NUMBER(3) NOT NULL, DT_EFFECT_F DATE NOT NULL, DT_EFFECT_T DATE, IS_VALID NUMBER(1) DEFAULT 1 NOT NULL, NUM_CHANGEDBY NUMBER(5) NOT NULL, DT_CHANGE DATE primary key DEFAULT sysdate NOT NULL, IS_LOCK NUMBER(1) DEFAULT 0 NOT NULL )
How can update only one attributeCesar October 3, 2012 at 10:23 PM
Hi! This is an Excelent tutorial. How can I do, if I need update only one attribute and keep the other values from attributes. regards
Post your Comment