本文介绍如何在Oracle数据库中查看存储过程，并提供了添加索引和外键约束的SQL语句示例。
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.
扫一扫
526
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
