demo01.sql

Expert Oracle Database Architecture 9i and 10g sql源码

select empno, ename, sal from emp where deptno = 10;
variable empno number
variable ename varchar2(20)
variable sal number
exec :empno := 7934; :ename := 'MILLER'; :sal := 1300;
select empno, ename, sal
from emp
where empno = :empno
  and ename = :ename
  and sal = :sal
  for update nowait
/
update emp
set ename = :ename, sal = :sal
where empno = :empno;
commit;