Home >> Oracle >> What is key in Oracle

What is key in Oracle

If no. of rows / tuples are very large then accessing any row will be very time consuming. so, in order to make searching yfaster key concept is introduced.

It is defined as an attribute or single attribute or group of attribute which is used to uniquely identify each and every row / tuple uniquely.

Post Your Comment

Next Questions
What is Super Key
What is Candidate Key
What is Primary Key
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

Copyright ©2022 coderraj.com. All Rights Reserved.