摘要:
参考文章: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 阅读全文
摘要:
/*创建唯一索引(unique index)*/SQL> create table tab_idx(id int,name varchar2(24));Table created.SQL> desc tab_idx; Name Null? Type ----------------------------------------- -------- ---------------------------- ID NUMB... 阅读全文