One to many using a primary-key and foreign-key relationship : Primary Key « Table « Oracle PL/SQL Tutorial

SQL>
SQL>
SQL> CREATE TABLE Programmer
  2     (lect_id    VARCHAR2(10) NOT NULL,
  3      lect_name  VARCHAR2(20),
  4      PRIMARY KEY (lect_id));

Table created.

SQL>
SQL> CREATE TABLE Course
  2     (course_id        VARCHAR2(10) NOT NULL,
  3      course_name      VARCHAR2(20),
  4      lect_id          VARCHAR(10),
  5      PRIMARY KEY (course_id),
  6      FOREIGN KEY (lect_id) REFERENCES Programmer (lect_id)
  7      ON DELETE CASCADE);

Table created.

SQL>
SQL> drop table Programmer cascade constraints;

Table dropped.

SQL> drop table Course cascade constraints;

Table dropped.

6.15.Primary Key
	6.15.1.	Create a table with primary key, VARCHAR type column and date type column with default value
	6.15.2.	Alter table to insert primary key
	6.15.3.	Use combined column as the primary key
	6.15.4.	Try to add two primary keys to one table
	6.15.5.	All columns as primary key
	6.15.6.	One to many using a primary-key and foreign-key relationship
	6.15.7.	One-to-one using a primary-key and foreign-key relationship
	6.15.8.	Use three columns as primary key