Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 212367 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 set up autotrace for a user account?
What are a collation and state the different types of collation sensitivity?
What is a tns service name?
What is a system tablespace?
What is the difference between post-database commit and post-form commit?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
How can I create database in oracle?
List out the difference between commit, rollback, and savepoint?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
Give the different types of rollback segments.
How to invoke the data pump import utility?
How to define an oracle sub procedure?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
What are the uses of Database Trigger ?
How a database is related to tablespaces?
