Reference column from another column : References « Table « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Table
3. References

SQL>
SQL> CREATE TABLE compact_discs (
  2     ID      INTEGER NOT NULL,
  3     title   VARCHAR2(60),
  4     artist  VARCHAR2(60),
  5     label   VARCHAR2(60),
  6     PRIMARY KEY (ID)
  7  );

Table created.

SQL>
SQL> INSERT INTO compact_discs VALUES (100, 'W', 'B', 'A');

1 row created.

SQL>
SQL> CREATE TABLE cd_keywords (
  2     cd_id        INTEGER NOT NULL REFERENCES compact_discs (id),
  3     keyword      VARCHAR2(60) NOT NULL,
  4     PRIMARY KEY  (cd_id, keyword)
  5  );

Table created.

SQL>
SQL> INSERT INTO cd_keywords VALUES (100, 'L');

1 row created.

SQL> INSERT INTO cd_keywords VALUES (100, 'M');

1 row created.

SQL>
SQL> drop table cd_keywords;

Table dropped.

SQL> drop table compact_discs;

Table dropped.

SQL>