whereclause.sql

来自「Oracle 9i PL/SQL程序设计的随书源码」· SQL 代码 · 共 45 行

REM WhereClause.sql
REM Chapter 4, Oracle9i PL/SQL Programming by Scott Urman
REM This script demonstrates several different WHERE clauses.

DECLARE
  v_Department  CHAR(3);
BEGIN
  v_Department := 'CS';
  -- Remove all Computer Science classes
  DELETE FROM classes
    WHERE department = v_Department;
END;
/

DECLARE
 Department  CHAR(3);
BEGIN
  Department := 'CS';
  -- Remove all Computer Science classes
  DELETE FROM classes
    WHERE department = Department;
END;
/

<<l_DeleteBlock>>
DECLARE
  Department  CHAR(3);
BEGIN
  Department := 'CS';
  -- Remove all Computer Science classes
  DELETE FROM classes
    WHERE department = l_DeleteBlock.Department;
END;
/

DECLARE
 v_Department  VARCHAR2(3);
BEGIN
  v_Department := 'CS';
  -- Remove all Computer Science classes
  DELETE FROM classes
    WHERE department = v_Department;
END;
/