primary keys oracle code example

Example 1: add primary key constraint in oracle

-- Adding Using alter
ALTER TABLE table_name
ADD CONSTRAINT constraint_name PRIMARY KEY (column1, column2, ... column_n);

Example 2: drop primary key oracle

-- Dropping Using alter
ALTER TABLE table_name
DROP CONSTRAINT constraint_name;