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
Is the After report trigger fired if the report execution fails ?
What is the best way to do multi-row insert in oracle?
What is oracle used for?
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??
How to open a cursor variable?
Write a syntax for update query in oracle?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
Can we convert a date to char in oracle and if so, what would be the syntax?
What is the fastest query method to fetch data from the table?
How to change system global area (sga) in oracle?
> 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?
How to use windows user to connect to the server?
What are the uses of linked server and explain it in detail?
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.
How to drop a stored procedure in oracle?