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 do you mean by stored procedures? How do we use it?

517

---

Why are aggregate functions called so?

510

---

How do I run pl sql in sql developer?

626

---

Explain what is a column in a table?

569

---

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

532

---

---

How do you determine the current isolation level? : Transact sql

575

---

What are different types of triggers?

554

---

How do I run a sql trace?

518

---

what is a cursor? : Sql dba

552

---

Is time a data type in sql?

478

---

What is the difference between explicit and implicit cursors in oracle?

512

---

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

1556

---

Explain autonomous transaction.

632

---

What is the difference between rename and alias?

705

---

Can we insert in sql function?

537

---