Oracle

Oracle（一）

DDL

创建表：CREATE TABLE

例:

CREATE TABLE teacher
(
      TID BUMBER(3) NOT NULL UNIQUE,
      TNAME VARCHER2(20),
      TAGE NUMBER(3),
      TGENDER CHAR(1)
);

---

---

修改表：ALERT TABLE

例：

ALTER TABLE teacher ADD TBIRTHDAY DATE;

---

---

删除表：DROP TABLE

例：

DROP TABLE teacher;

---

---

补充：

1. 创建索引：create index callen_index on teacher(tname);
   

---

2. 创建视图：create view callen_view as select tname,tgender from teacher;
   
   

---

3. 删除索引：drop index callen_index;(点两次执行后出现下面结果)
   

---

4. 删除视图：drop view callen_view;