how to update multiple tables in oracle DB?
- by murali
hi,
i am using two tables in my oracle 10g. the first table having the keyword,count,id(primary key) and my second table having id, timestamp..
but i am doing any chages in the first table(keyword,count) it will reflect on the my second table timestamp.. i am using id as reference for both the tables...
table1:
CREATE TABLE Searchable_Keywords
(KEYWORD_ID NUMBER(18) PRIMARY KEY,
KEYWORD VARCHAR2(255) NOT NULL,
COUNT NUMBER(18) NOT NULL,
CONSTRAINT Searchable_Keywords_unique UNIQUE(KEYWORD)
);
table2:
CREATE TABLE Keywords_Tracking_Report
(KEYWORD_ID NUMBER(18),
PROCESS_TIMESTAMP TIMESTAMP(8)
);
how can update one table with reference of another table..
help me plz...