1、plsql上新建用戶

      CREATE  USER wjbcsIDENTIFIED BY wjbcs;

     GRANT RESOURCE  TO wjbcs;

     GRANT  CONNECT  TO wjbcs;

      登陸plsql后，新建一個(gè)用戶：wjbcs及對(duì)應(yīng)的密碼：wjbcs

2、查詢(xún)Oracle被關(guān)聯(lián)表的子表

       select * from user_constraints where R_CONSTRAINT_NAME in

                                         (select constraint_name from user_constraints where table_name = 'HORDE') ;