Difference between primary key and unique key ?
Answer Posted / mudigouda patil
PRIMARY KEY
1)TABLE CAN NOT HAVE MORE THAN ONE PRIMARY KEY.
2)PK DOES NOT ALLOW NULL VALUES.
UNIQUE KEY
1)TABLES CAN HAVE MORE THAN ONE UNIQUE KEY.
2)UNIQUE KEY ALLOWS NULL VALUES.
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
How to open a cursor variable?
What is columnar storage what is the advantage?
if you ctreate table identity
How to grant create session privilege to a user in oracle?
Explain the use of control file?
How to retrieve data from an explicit cursor?
What is a schema in oracle?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
How to retrieve the count of updated rows?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
What is oracle sid?
What is format trigger?