2012年4月24日
创建对象类型
摘要： Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 Connected as SYSSQL> select * from store.purchases; PRODUCT_ID CUSTOMER_ID QUANTITY--------------------------------------- --------------------------------------- --------------------------------------- 1 4 1 2 4 1SQL> sele 阅读全文
posted @ 2012-04-24 16:25 残阳飞雪 阅读(2539) 评论(0) 推荐(0) 编辑
修改继承类型
摘要： SQL> alter type person_typ not final cascade;Type altered 阅读全文
posted @ 2012-04-24 15:18 残阳飞雪 阅读(126) 评论(0) 推荐(0) 编辑
向用户授予对象特权
摘要： grant select,insert,update on store.products to SYS;grant create session,create user,create table to SYS;grant execute any procedure to SYS with admin option;create user roy identified by williams; 阅读全文
posted @ 2012-04-24 12:22 残阳飞雪 阅读(111) 评论(0) 推荐(0) 编辑