摘要: 参考文章:http://www.cnblogs.com/xd502djj/archive/2009/07/02/1515509.html1、创建dblinkSQL> show userUSER is "SYS"SQL> create public database link ora9i_dblink connect to scott identified by tiger using 'ORA9IDB';Database link created.创建dblink,createpublicdatabaselinklink_nameconnectt 阅读全文
posted @ 2013-07-27 11:33 ArcerZhang 阅读(242) 评论(0) 推荐(0) 编辑
摘要: /*创建唯一索引(unique index)*/SQL> create table tab_idx(id int,name varchar2(24));Table created.SQL> desc tab_idx; Name Null? Type ----------------------------------------- -------- ---------------------------- ID NUMB... 阅读全文
posted @ 2013-07-27 10:37 ArcerZhang 阅读(273) 评论(0) 推荐(0) 编辑