1.创建表
语法:
CREATE TABLE TABLE_NAME(
FILED_NAME DATATYPE NOT NULL,
FILED_NAME DATATYPE NOT NULL,
FILED_NAME DATATYPE,
FILED_NAME DATATYPE NOT NULL,
CONSTRAINT PK_NAME PRIMARY KEY (FILED_NAME)
using index tablespace TABLESPACE_NAME1
)
tablespace TABLESPACE_NAME2;
comment on table TABLE_NAME is 'COMMENT';
comment on COLUMN TABLE_NAME.FILED_NAME is 'COMMENT';
comment on column TABLE_NAME.FILED_NAME is 'COMMENT';
comment on column TABLE_NAME.FILED_NAME is 'COMMENT';
comment on column TABLE_NAME.FILED_NAME is 'COMMENT';
示例:
--1.建表
--学生表
CREATE TABLE STUDENT(
STUDENT_ID NUMBER(12) NOT NULL,
STU_NAME VARCHAR2(255) NOT NULL,
AGE NUMBER(6),
SEX CHAR(1) NOT NULL,
CONSTRAINT PK_
语法:
CREATE TABLE TABLE_NAME(
FILED_NAME DATATYPE NOT NULL,
FILED_NAME DATATYPE NOT NULL,
FILED_NAME DATATYPE,
FILED_NAME DATATYPE NOT NULL,
CONSTRAINT PK_NAME PRIMARY KEY (FILED_NAME)
using index tablespace TABLESPACE_NAME1
)
tablespace TABLESPACE_NAME2;
comment on table TABLE_NAME is 'COMMENT';
comment on COLUMN TABLE_NAME.FILED_NAME is 'COMMENT';
comment on column TABLE_NAME.FILED_NAME is 'COMMENT';
comment on column TABLE_NAME.FILED_NAME is 'COMMENT';
comment on column TABLE_NAME.FILED_NAME is 'COMMENT';
示例:
--1.建表
--学生表
CREATE TABLE STUDENT(
STUDENT_ID NUMBER(12) NOT NULL,
STU_NAME VARCHAR2(255) NOT NULL,
AGE NUMBER(6),
SEX CHAR(1) NOT NULL,
CONSTRAINT PK_