Which data type doesn't allow null data type?
Answers were Sorted based on User's Feedback
Answer / shailesh
First of all the way this question is asked is totally wrong. The learner may have to ask which data type does not allow null values.
All data types will allow to insert null values unless the Primary Key or Not Null constraint is defined on a column.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / rajesh
The first answer is wrong, because 'NULL' is string its not null.
If u give null in insert query as second parameter the row will be inserted.
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / nanne saheb c
Can't insert NULL value in DATE data type. Please find the below practical as example.
CREATE TABLE Example(
name VARCHAR(30),
regist DATE,
PRIMARY KEY(name)
);
INSERT INTO Example VALUES ('anyname','NULL');
ORA-01841: (full) year must be between -4713 and +9999, and not be 0
Is This Answer Correct ? | 3 Yes | 10 No |
can i create trigger on synonym is it possible or not please help me
How many triggers can be applied on a table?
How do I install sql?
What are types of joins?
Is hadoop a nosql?
What is an Integrity Constraint?
What is the use of stored procedures?
What are the rules to be applied to nulls whilst doing comparisons?
What are the benefits of pl/sql packages?
how to use in conditions? : Sql dba
What is data type in sql?
How do I create an index in word?