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

how would you get the current date in mysql? : Sql dba

531

---

what are the 'mysql' command line options? : Sql dba

547

---

what are the different type of sql's statements ? : Sql dba

512

---

Is it possible to include an insert statement on the same table to which the trigger is assigned?

555

---

Why do we need cursors in pl sql?

512

---

---

What are secondary keys?

553

---

What is foreign key in sql with example?

504

---

What is write ahead logging in sql server?

554

---

Should I use mbr or gpt?

531

---

Can a trigger call a stored procedure?

530

---

What does <> sql mean?

528

---

how to get help information from the server? : Sql dba

524

---

Is pl sql better than sql?

542

---

What is lexical units in pl sql?

565

---

Can we insert data into view?

518

---