建立用户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@]