Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

what is a partial primary key? and how to implement it?

Hi There,

While going through oracle documentation, I found a brief info about Partial Primary Key; I am unable to interpret the information. Hence, trying to find if anyone can assist me to understand its use-case.

Below is the published information:

Some of the methods you use to perform multi-row operations allow, or even require, a partial primary key. A partial primary key is, simply, a key where only some of the fields comprising the row's primary key are specified.

I have attached the link for the oracle-webpage from which I took the information. The title of the paragarah is: ‘Partial Primary Keys’.

Thank you for giving your valuable time.

https://docs.oracle.com/en/database/other-databases/nosql-database/23.3/java-driver-table/primary-keys.html#GUID-DA57D016-74DF-4BE2-BF84-90748D5FE081

Comments
Post Details
Added on Feb 19 2024
1 comment
596 views