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 is the difference between the conventional and direct path loads? : aql loader

1391

---

Which sql statement is used to delete data from a database?

953

---

What is bind variable in pl sql?

1045

---

What is the difference between join and natural join?

924

---

Is sql injection illegal?

1012

---

Which is better stored procedure or query?

955

---

How can we find duplicate records in a table?

939

---

Mention what is the use of function "module procedure" in pl/sql?

1045

---

What is sap sql anywhere?

1066

---

The in operator may be used if you know the exact value you want to return for at least one of the columns.

1122

---

What are sql data types?

1015

---

Can a foreign key be a duplicate?

903

---

What are hotfixes and patches?

941

---

what is the stuff function and how does it differ from the replace function? : Sql dba

1040

---

What is a primary key called that is made up of more than one field?

1339

---