Difference between primary key and unique key ?
- 77 Answers
- 190730 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
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
How to create an oracle database?
What is a lookup table in oracle?
How to export your own schema?
How to see the table columns used in an index?
What is the best way to do multi-row insert in oracle?
Why does for update in oracle 8 cause an ora-01002 error?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
Explain compound trigger in oracle?
How to create a new table in oracle?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
what is the scripts in data base?
What is tns service name?
How to write a query with an inner join in oracle?
Can we use bind variables in oracle stored procedure?
