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

Can we write ddl statements in functions?

1116

---

Which sorts rows in sql?

1019

---

Does sap use sql?

993

---

What does pl sql stand for?

1111

---

Can a select statement fire a trigger?

1158

---

Why truncate is faster than delete?

1111

---

What are the usages of sql?

1058

---

How do I view tables in sql developer?

946

---

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4283

---

Is primary key an index?

991

---

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

1053

---

What is view? Can we update view

1439

---

What is string data type in sql?

1140

---

What is a Mapplet?

1120

---

what is sql profiler? : Sql dba

1042

---