建立用户wangyi:
SQL>create user wangyi identified by wangyi default tablesapce testdata;
赋予DBA的权限:
SQL> grant conn,dba to wangyi;
建立department和employees表:
SQL>CREATE TABLE employees(
employee_id NUMBER(6),
first_name VARCHAR2(20),
last_name VARCHAR2(25),
email VARCHAR2(25),
phone_number VARCHAR2(20),
hire_date DATE DEFAULT SYSDATE,
job_id VARCHAR2(10),
salary NUMBER(8,2),
commission_pct NUMBER (2,2),
manager_id NUMBER(6),
department_id NUMBER(4) )
tablespace testdata;
SQL>CREATE TABLE department dep_id number(6), dep_name varchar(20) );
[@more@]来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7875565/viewspace-920775/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7875565/viewspace-920775/