Difference between primary key and unique key ?

Answer Posted / lucky

Primary key not accepts to null values in database, but
uniqe key accepts to the null values in database.

Each table having only one PRIMARY KEY.And my contain many
UNIQUE KEYS.
PRIMARY KEY is identity of each row. UNIQUE KEY also
identity of each row.
BOTH keys will not contain repeated value.
BUT UNIQUE KEY will contain NULL value but PRIMAY key will
not contain NULL value.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is the After report trigger fired if the report execution fails ?

2726


What is the best way to do multi-row insert in oracle?

849


What is oracle used for?

776


There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

1825


How to open a cursor variable?

817


Write a syntax for update query in oracle?

815


Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1636


Can we convert a date to char in oracle and if so, what would be the syntax?

798


What is the fastest query method to fetch data from the table?

1122


How to change system global area (sga) in oracle?

818


> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

1832


How to use windows user to connect to the server?

763


What are the uses of linked server and explain it in detail?

838


Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

1777


How to drop a stored procedure in oracle?

814