创建表:
create table student(
StudentId number (6),--学号
LoginPwd varchar(20),--密码
StudentName varchar(50),--姓名
Sex char(2),--性别
Gradeld Number(6),--所在年级
Phone number(15),--联系电话
Address varchar2(255),--现住址
BornDate Date,--出生日期
Emile varchar2(50)--电子邮件
);
增:insert into 表名 (属性列)values(值)
insert into Student values(1001,’123456’,’赵六’,’男’,1507,120,’北京’,’23-5月-1995’,’@10422’)
insert into Student (StudentId number,LoginPwd,StudentName) values(1002,’456’,’李四’)
删:delete from 表名 条件
delete from Student where studentid=1001
改:update 表名 set 属性=’值’ 条件
update student set studentname=’李东’ where StudentId=1002
查:select 属性列 from 表名 条件
select * from Student
select s.sal from Student s
select s.studentname from Student s
select s