Home >> Oracle >> What is Primary Key in Oracle

What is Primary Key in Oracle

1-Primary key is one or more columns in a table used for uniquely identify every row in the table.

2-Primary key will not allow duplicates values.

3-Primary key will not allow NULL values.

4-Only one primary key in a table.

5-Primary key cannot be LONG data types.

6-Unique index created automatically.

Post Your Comment

Next Questions
What is Unique Key
What is Foreign Key
Function
Procedure
Cursor
Trigger
Before Trigger
After Trigger
DROP Trigger
DISABLE Trigger
ENABLE Trigger
Aggregate Functions
APPROX_COUNT_DISTINCT() Aggregate function
AVG() aggregate function
COLLECT() Aggregate Function
CORR() Aggregate Function
CORR_*
COUNT() aggregate function
COVAR_POP Aggregate Function
COVAR_SAMP() Aggregate Function
CUME_DIST() Aggregate Function
DENSE_RANK() Aggregate Function
FIRST() aggregate function
GROUP_ID() Aggregate Function
GROUPING() Aggregate Function

Copyright ©2022 coderraj.com. All Rights Reserved.