oracle数据库初学

首先，先来创建表空间和表用户

/*创建表空间*/
create tablespace waterboss
datafile 'c:\waterboss.dbf'
size 100m
autoextend on
next 10m

 /*创建表用户*/
create user tableuser

default tablespace waterboss
/*用户赋权，就可以用作登录*/
grant dba to wateruser

创建表：

/*业主类型表*/
create table T_OWNERTYPE(
      ID NUMBER PRIMARY KEY,
      NAME VARCHAR2(30)
);
/*价格表*/
create table T_PRICETABLE(
     ID NUMBER PRIMARY KEY,
     PRICE NUMBER(10,2),
     OWNERTYPEID NUMBER,
     MINNUM NUMBER(10,2),
     MAXNUM NUMBER(10,2)
);
/*区域表*/
create table T_AREA(
       ID NUMBER PRIMARY KEY,
       NAME VARCHAR2(30)
);
/*收费员表*/
create table T_OPERATOR(
       ID NUMBER PRIMARY KEY,
       NAME VARCHAR2(30)
);
/*地址表*/
create table T_ADDRESS(
       ID NUMBER PRIMARY KEY,
       NAME VARCHAR2(30),
       AREAID NUMBER,
       OPERATORID NUMBER
);
/*业主表*/
create table T_OWNERS(
    ID NUMBER PRIMARY KEY,
    NAME VARCHAR2(30),
    ADDRESS NUMBER,
    HOUSENUMBER VARCHAR2(30),
    WATERMATER VARCHAR2(30),
    ADDDATE DATE,
    OWNERTYPEID NUMBER
);
/*收费台账*/
create table T_ACCOUNT(
       ID NUMBER PRIMARY KEY,
       OWNERID NUMBER,
       OWNERTYPEID NUMBER,
       AREAID NUMBER,
       YEAR CHAR(4),
       MOUTH CHAR(4),
       NUM0 NUMBER,
       NUM1 NUMBER,
       USERNUM NUMBER,
       METERUSERID NUMBER,
       METERDATE DATE,
       MONEY NUMBER(10,2),
       ISFEE CHAR(4),
       FEEDATE DATE,
       FEEUSERID NUMBER
);
/*表的创建与修改*/
CREATE TABLE USERDEMO(
       ID NUMBER PRIMARY KEY,
       NAME VARCHAR2(20),
       AGE DATE
);
ALTER TABLE USERDEMO ADD (BIRTHDAY DATE)

ALTER TABLE USERDEMO MODIFY (AGE NUMBER)

ALTER TABLE USERDEMO RENAME COLUMN AGE TO ASD

//删除一个字段
alter table userdemo drop column asd