二 DML命令
1 插入数据举例:
Java代码
DECLARE
v_temp person.name%TYPE;
BEGIN
SELECT username
INTO v_ temp
FROM person
Where usernumber=95001;
INSERT INTO person(usernumber, name, sex, email)
VALUES(95003, v_ temp , ' 男', ‘admin@163.com’);
END;
/
DECLARE
v_temp person.name%TYPE;
BEGIN
SELECT username
INTO v_ temp
FROM person
Where usernumber=95001;
INSERT INTO person(usernumber, name, sex, email)
VALUES(95003, v_ temp , ' 男', ‘admin@163.com’);
END;
/
注释:将表中学号是95001的学生姓名取出再加上其他的信息作为一条记录重新插入到person表中。先通过select语句找出姓名,存放到临时变量中,然后再通过insert语句插入到数据库中。
2 修改数据举例
Java代码
Declare
V_age person.age%type :=20;
Begin
Update person
Set age=v_age
Where username=’admin’;
End;
/
Declare
V_age person.age%type :=20;
Begin
Update person
Set age=v_age
Where username=’admin’;
End;
/
3 删除数据举例
Java代码
Declare
V_number person.number%type :=95003;
Begin
Delete
From person
Where number=v_number;
End;
/
Declare
V_number person.number%type :=95003;
Begin
Delete
From person
Where number=v_number;
End;
/
1 插入数据举例:
Java代码
DECLARE
v_temp person.name%TYPE;
BEGIN
SELECT username
INTO v_ temp
FROM person
Where usernumber=95001;
INSERT INTO person(usernumber, name, sex, email)
VALUES(95003, v_ temp , ' 男', ‘admin@163.com’);
END;
/
DECLARE
v_temp person.name%TYPE;
BEGIN
SELECT username
INTO v_ temp
FROM person
Where usernumber=95001;
INSERT INTO person(usernumber, name, sex, email)
VALUES(95003, v_ temp , ' 男', ‘admin@163.com’);
END;
/
注释:将表中学号是95001的学生姓名取出再加上其他的信息作为一条记录重新插入到person表中。先通过select语句找出姓名,存放到临时变量中,然后再通过insert语句插入到数据库中。
2 修改数据举例
Java代码
Declare
V_age person.age%type :=20;
Begin
Update person
Set age=v_age
Where username=’admin’;
End;
/
Declare
V_age person.age%type :=20;
Begin
Update person
Set age=v_age
Where username=’admin’;
End;
/
3 删除数据举例
Java代码
Declare
V_number person.number%type :=95003;
Begin
Delete
From person
Where number=v_number;
End;
/
Declare
V_number person.number%type :=95003;
Begin
Delete
From person
Where number=v_number;
End;
/