Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210062 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
Can you tell me how to add new column in existing views?how?How is possible?
What is data type in oracle?
What is the usage of analyze command in oracle?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What are the database administrators utilities available?
What is MTTR advisor in Oracle?
How to load data through external tables?
Why is oracle so popular?
What is varray?
What are the uses of Database Trigger ?
Explain mutating triggers.
How to write a query with a right outer join in oracle?
In oracle there is column command, how will you explain that?
How to sort output in descending order in oracle?
How to bring a tablespace online?
