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

What are the ways on commenting in a pl/sql code?

1193

---

What is the difference between microsoft access and sql server?

1100

---

What is sql trigger example?

1108

---

What is the difference between drop and truncate commands?

1107

---

What does select * from mean in sql?

3321

---

What is oracle pl sql developer?

1019

---

Is sql a programming?

1022

---

How do I view tables in sql developer?

999

---

What is the basic structure of an sql?

1144

---

What is sql prepared statement?

1029

---

What are synonyms in sql?

1014

---

What is use of package in pl sql?

1065

---

what is the difference difference between procedure and packages

10525

---

What is a relationship and what are they?

1222

---

what are enums used for in mysql? : Sql dba

1225

---