b.
例如:
ALTER TABLE STUDENT MODIFY(NAME VARCHAR2(25));
将已经存在的表删除,语句句法:表名;; 命令的语法为:模式名。] {表名|视图名||} .*…| 表达式[列别名] ]…表别名] ]…条件]条件 CONNECT BY 条件]表达式[,表达式] …[HAVING条件]命令表达式|位置} [ASC|DESC] [, {表达式|位置[ASC|DESC]}]…]
(1) 查询年纪为12的学生姓名;
SELECT STUDENT.NAME FROM STUDENT WHERE AGE=12;
(2) 查询年纪在12至16岁之间的学生姓名;
SELECT STUDENT.NAME FROM STUDENT WHERE AGE BETWEEN 12 AND 16;
(3) 查询年纪不在12至16岁之间的学生姓名;
SELECT STUDENT.NAME FROM STUDENT WHERE AGE NOT BETWEEN 12 AND 16;
(4) 查询所有姓名以A开头的学生的姓名;
例如:对于STUDENT表:
SELECT STUDENT.NAME FROM STUDENT WHERE NAME LIKE 'A%';
(5) 列出所有学生年纪的和,年纪的平均值,最大值,最小值,最大值与最小值之间的差值;
[1] [2] [3] [4] [5] [6]