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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
320 views