dupvalonindex.sql

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

REM DupValOnIndex.sql
REM Chapter 7, Oracle9i PL/SQL Programming by Scott Urman
REM This block will raise the DUP_VAL_ON_INDEX exception.

BEGIN
  INSERT INTO students (id, first_name, last_name)
    VALUES (20000, 'John', 'Smith');
  INSERT INTO students (id, first_name, last_name)
    VALUES (20000, 'Susan', 'Ryan');
END; 
/