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 |
What is %s in sql?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
what are integrity rules?
What is the difference between sql and mysql?
When sql appeared?
What is denormalization in a database?
What is file based approach?
What is a natural join?
What is the difference between cluster and non-cluster index?
What is integrity constraints?
what is mean by forward declaration and where we'll use it.
How to count the no of records of a table without using COUNT function?