Answer Posted / 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 |
Post New Answer View All Answers
What is asqueryable?
What are the types of operators available in sql?
How do I remove sql plus from windows 10?
how can you see all indexes defined for a table? : Sql dba
How do I view a sql database?
What are different functions in sql?
What is a design view?
What is cursor and why it is required?
Which table is left in join?
What is trigger point?
How does left join work in sql?
What are commit, rollback, and savepoint?
Explain the update statement in sql
What do you mean by dbms? What are its different types?
how can we submit a form without a submit button? : Sql dba