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

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

1958

---

what is normalization? : Sql dba

1015

---

What are basic techniques of indexing?

1320

---

What is the reports view in oracle sql developer?

925

---

Determine if oracle date is on a weekend?

981

---

what is dbms? : Sql dba

932

---

What is a table partition?

1036

---

What is the difference between instead of trigger and after trigger?

948

---

Why is pl sql used?

937

---

What is column?

940

---

How to check if a column is nullable before setting to nullable?

1055

---

What is exception? What are the types of exceptions?

1031

---

Why is sql better than hql?

920

---

Is postgresql a nosql database?

1074

---

How does index help in query performance?

967

---