Primary Key

In Oracle, Primary key is the column which has unique values, and it cannot be null. In a table, there can be only one primary key.

Primary Key - Using CREATE TABLE statement

Syntax:

CREATE TABLE table_name
(
  column1 datatype null/not null,
  column2 datatype null/not null,
  ...
  CONSTRAINT constraint_name PRIMARY KEY (column1, column2, ... column_n)
);

Example

CREATE TABLE Test2(ID Number, NAME Varchar2 CONSTRAINT test2_pk PRIMARY KEY (ID));

Primary Key - Using ALTER TABLE statement

Syntax:

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

Example

Drop Primary Key

Syntax:

ALTER TABLE table_name
DROP CONSTRAINT constraint_name;

Example

Disable Primary Key

Syntax:

ALTER TABLE table_name
DISABLE CONSTRAINT constraint_name;

Example

Primary Key in Oracle Disable Primary Key

Enable Primary Key

Syntax:

ALTER TABLE table_name
ENABLE CONSTRAINT constraint_name;

Example

Primary Key in Oracle Enable Primary Key

Next TopicTutorial

← prev next →

Help Others, Please Share

Learn Latest Tutorials

Arduino

Digital E.

Adwords

MySQL

Python

Smartsheet

Affiliate M.

Testing

Proc*C

SMM

GDB

Fuzzy Logic

Preparation

Aptitude

Reasoning

Verbal A.

Interview

Company

Trending Technologies

AWS

Selenium

Cloud

Hadoop

ReactJS

D. Science

Angular 7

Blockchain

Git

DevOps

B.Tech / MCA

DBMS

DAA

C. Network

Compiler D.

COA

D. Math.

E. Hacking

C. Graphics

Software E.

Web Tech.

Cyber Sec.

Automata

C++

Java

.Net

Python

Programs

Control S.

Data Mining

Javatpoint Services

JavaTpoint offers too many high quality services. Mail us on hr@javatpoint.com, to get more information about given services.

Website Designing
Website Development
Java Development
PHP Development
WordPress
Graphic Designing
Logo
Digital Marketing
On Page and Off Page SEO
PPC
Content Development
Corporate Training
Classroom and Online Training
Data Entry

Training For College Campus

JavaTpoint offers college campus training on Core Java, Advance Java, .Net, Android, Hadoop, PHP, Web Technology and Python. Please mail your requirement at hr@javatpoint.com.
Duration: 1 week to 2 week

^{Like/Subscribe us for latest updates or newsletter}

Oracle Tutorial

Oracle Tables

Oracle Views

Oracle Query

Oracle Clauses

Oracle Operators

Oracle Joins

Oracle Advance

Oracle Misc

Interview Questions

Primary Key

Primary Key - Using CREATE TABLE statement

Syntax:

Example

Primary Key - Using ALTER TABLE statement

Syntax:

Example

Drop Primary Key

Syntax:

Example

Disable Primary Key

Syntax:

Example

Enable Primary Key

Syntax:

Example

Help Others, Please Share

Learn Latest Tutorials

Preparation

Trending Technologies

B.Tech / MCA

Javatpoint Services

Training For College Campus