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 are the different tcl commands in sql?
Difference between truncate, delete and drop commands?
difference between cursor and procedure in a package
What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?
What is java sql driver?
Can you have a foreign key without a primary key?
Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?
Why we use cross join?
When do we use triggers?
If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?
Is sql dba a good career? : SQL DBA
What is diff between bulk collect and forall