oracle 常用sql

插入外键：

主表：EXP_F_CONREIMB_EXPENSELIST，主表字段：GID 子表：EXP_F_CONREIMB_EXPENSE_INVLIST 子表字段：INVOICECODE

ALTER TABLE EXP_F_CONREIMB_EXPENSE_INVLIST ADD CONSTRAINT FK_INVOICECODE FOREIGN KEY (INVOICECODE) REFERENCES EXP_F_CONREIMB_EXPENSELIST(GID);