Difference between primary key and unique key ?
- 77 Answers
- 191036 Views
- Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions, I also Faced
- E-Mail Answers
Answer Posted / arpit sachan
Primary key Accept only one Null Value...But a Unique key Accept one or More Null value........
create table #foo(id varchar(5)primary key,name varchar(10));
insert into #foo('','Your name');
---------->> see the result.....
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to delete a column in an existing table?
What is the dynamic sql in oracle?
What is oracle and what are its different editions?
Explain the use of grant option in exp command.
What is sharded cluster?
Difference between oracle's plus (+) notation and ansi join notation?
What privilege is needed for a user to delete rows from tables in another schema?
What is blob data type in oracle?
How to view the tablespaces in the current database?
Can a formula column referred to columns in higher group ?
What is raw datatype in oracle?
What is oracle rownum?
What is an oracle user role?
How to create an oracle testing table?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
