7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
insert
declare
v_empno emp.empno%type := &empno;
v_ename emp.ename%type := ‘&ename’;
v_salary emp.sal%type := &sal;
begin
insert into emp(empno,ename,sal)
values(v_empno,v_ename,v_salary);
commit;
end;
update
declare
v_empno emp.empno%type;
v_salary emp.sal%type :=&sal;
begin
update emp set sal=v_salary where empno=1234;
commit;
end;
delete
declare
v_empno emp.empno%type :=&eno;
begin
delete emp where empno=v_empno;
commit;
end
在pl/sql中& 表示弹出框提示你输入值