1.在查看oracle里查看存储过程:
** desc user_source;
** select line|| ' ' || text from user_source where lower(name) ='存储过程名' order by line;
2.alert table ORDERS add index IDX_CUSTOMER(CUSTOMER_ID),
add constraint FK_CUSTOMER foregin key(CUSTOMER_ID)
references CUSTOMERS(ID);
3.
** desc user_source;
** select line|| ' ' || text from user_source where lower(name) ='存储过程名' order by line;
2.alert table ORDERS add index IDX_CUSTOMER(CUSTOMER_ID),
add constraint FK_CUSTOMER foregin key(CUSTOMER_ID)
references CUSTOMERS(ID);
3.