Difference between primary key and unique key ?
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 we connect to ORACLE db using Windows Authentication?
What is control file used for?
How many types of tables supported by oracle?
What is a cognitive schema?
How to start your 10g xe server?
How to delete an existing row from a table in oracle?
What is blob data type in oracle?
How to convert a date to char in oracle? Give one example.
What are the roles of dba?
How to speed up webrick?
What privilege is needed for a user to query tables in another schema?
How do you find current date and time in oracle?
How can we create the complete backup of data in the oracle.
How to bring a tablespace online?
How to drop a tablespace?