--向Student表中插入数据
INSERTINTOstudentALUES('1001',',20,to_date('2012-09-01','yyyy-MM-dd'));
INSERTINTO student VALUES('1002','hello',20,to_date('2012/09/01','yyyy/MM/dd'));
INSERTINTO student VALUES('1003','happy',20,to_date('2012-09-01','yyyy-MM-dd'));
INSERTINTO student VALUES('1005','李辰',23,to_date('2012/08/29','yyyy/mm/dd'));
--部分数据插入
INSERTINTO student(sno,NAME,age) VALUES('1004','honey',23);
--更新操作,讲学号为1001的学生你年龄修改为23,姓名修改为soney
UPDATE student
SET age = 25,NAME = 'soney'
WHERE sno = '1001';
--删除操作
DELETEFROM student WHERE age = 20;
--查询Student表
SELECT * FROM student;
--查询学号为1002的学生信息,oracle中字段的别名可以加as也可以不加,表的别名不能加as
SELECT * FROM student WHERE sno = '1002';
SELECT sno AS学号,NAME姓名,age 年龄,entrydate 入学日期
FROM student stu
WHERE sno = '1002';
--查询姓李的学生信息,模糊查询使用like,like后面的通配符有两个:
--百分号%:匹配任意多个字符,
--下划线_:匹配的是单个字符
SELECT * FROM student WHERENAMELIKE'李%';
SELECT sno,NAME,age,entrydate FROM student WHERENAMELIKE'%n%';
--查询姓名以A_开头的学生信息,如果查询的内容与通配符相同,使用escape关键字对通配符进行转义
SELECT sno,NAME,age,entryDate
FROM student
WHERENAMELIKE'A\_%'ESCAPE'\';