数据库小知识点

1、plsql上新建用户

      CREATE  USER wjbcsIDENTIFIED BY wjbcs;

     GRANT RESOURCE  TO wjbcs;

     GRANT  CONNECT  TO wjbcs;

      登陆plsql后，新建一个用户：wjbcs及对应的密码：wjbcs

2、查询Oracle被关联表的子表

       select * from user_constraints where R_CONSTRAINT_NAME in

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