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

757

---

What is substitution variable?

788

---

What do you mean by rowid?

708

---

what is self-join? : Sql dba

756

---

how would you enter characters as hex numbers? : Sql dba

720

---

---

How do I tune a sql query?

725

---

How does one load ebcdic data? : aql loader

827

---

Can we rollback after truncate?

754

---

What is lexical units in pl sql?

761

---

What is inner join in sql?

775

---

What are the types of triggers in sql?

700

---

How can you get sql*loader to commit only at the end of the load file? : aql loader

747

---

What is dense_rank?

697

---

How is indexing done in search engines?

721

---

what is timestamp in mysql? : Sql dba

742

---