dila puteh
Last Activity: Oct 5 '10, 04:43 PM
Joined: Sep 12 '10
Location:
-
What i mean is table in my database that is oracle can retrieve the data of other database like table in sql,my sql and prosgres -
data integration
Can i ask you about how to integrate between 4 database(oracle ,sql server,mysql and progres sql)?and what is coding to make all those data to be connect?Leave a comment:
-
it means that i have to insert the value of employee's table first before insert the value of order right?ok.i can understand now.thank you so much to help to solve this problem.Leave a comment:
-
How to solve ORA-02291: integrity constraint error
CREATE TABLE ORDER_PHARMACY(
Ord_ID VARCHAR2(10)
CONSTRAINT ORDER_PHARMACY_ Ord_ID_pk PRIMARY KEY
CONSTRAINT Ord_ID_nn NOT NULL,
Ord_Date DATE DEFAULT SYSDATE
CONSTRAINT ORDER_PHARMACY_ Ord_Date_nn NOT NULL,
Ord_Price VARCHAR2(10),
Ord_Qty NUMBER(10),
Emp_ID VARCHAR2(10)
CONSTRAINT ORDER_PHARMACY_ _Emp_ID_fk
REFERENCES EMPLOYEE(Emp_ID ));
... -
Error (ORA-00904) after i run for this command
CREATE TABLE ORDER_PHARMACY(
Ord_ID VARCHAR2(10)
CONSTRAINT ORDER_PHARMACY_ Ord_ID_pk PRIMARY KEY,
CONSTRAINT Ord_ID_nn NOT NULL,
Ord_Date DATE DEFAULT SYSDATE
CONSTRAINT ORDER_PHARMACY_ Ord_Date_nn NOT NULL,
Ord_Price VARCHAR2(10),
Ord_Qty NUMBER(10),
Emp_ID VARCHAR2(10)
CONSTRAINT ORDER_PHARMACY_ Emp_ID_fk
REFERENCES EMPLOYEE(Emp_ID ));
No activity results to display
Leave a comment: