Interested to Buy Any Domain ? << Click Here >> for more details...
Can we have more than one NULL in a column having unique
constraint?
- 12 Answers
- 16038 Views
- 247Customer, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / atikullah
No, I think unique constraint contain no duplicate value in
a column. There are only contains unique value
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / rammohan176
yes Unique constraint accept more than one null.... because null is always not equal to another null value.i.e null<>null.
if any body have doubt please check this
CREATE TABLE TEST1 ( ENO NUMBER CONSTRAINT EU UNIQUE,
NAME1 VARCHAR2(10))
INSERT INTO TEST1 (NAME1) VALUES('RAM')
INSERT INTO TEST1 (NAME1) VALUES('KARTHIK')
INSERT INTO TEST1 (NAME1) VALUES('SANTHOSH')
INSERT INTO TEST1 (NAME1) VALUES('SANDY')
| Is This Answer Correct ? | 0 Yes | 1 No |
What is system stored procedures?
What is constraints and its types?
How cand Optimize SQL Server Stored Procedures
What is the cpu pressure?
Can a unique index be created on a column, which contains null?
Explain the difference between control flow and data flow?
What is a transactions?
How to list all columns in a table using odbc_columns()?
How do we know if any query is retrieving a large amount of data or very little data?
A trigger can reference objects outside the current database? State true or false.
What stored by the msdb?
What is a full text index?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
