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 asqueryable?

951

---

What are the types of operators available in sql?

1050

---

How do I remove sql plus from windows 10?

1078

---

how can you see all indexes defined for a table? : Sql dba

976

---

How do I view a sql database?

1007

---

What are different functions in sql?

925

---

What is a design view?

916

---

What is cursor and why it is required?

1165

---

Which table is left in join?

958

---

What is trigger point?

977

---

How does left join work in sql?

985

---

What are commit, rollback, and savepoint?

967

---

Explain the update statement in sql

971

---

What do you mean by dbms? What are its different types?

1001

---

how can we submit a form without a submit button? : Sql dba

964

---