Answer Posted / naresh

View: - it is logical table,it doesn't contain any data,it's contain only select statement.
if you modify the data in view,it's immediately effect to the Base table.
it gets rowids same as the base table.
Materialized view: - M.V are mostly use in Data Marts.

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

565

---

What are the differences between implicit and explicit cursors?

530

---

What does the base_object_type column shows in the user.triggers data dictionary view?

584

---

how to select first 5 records from a table? : Sql dba

520

---

What is a full join?

536

---

---

What are procedures used for?

542

---

How do you rank data in sql?

527

---

Explain alias in sql?

594

---

What is meant by cursor in sql?

555

---

What is crud diagram?

521

---

How can you save or place your msg in a table?

531

---

What does an inner join do?

565

---

Why should I use postgresql?

572

---

what is a database transaction? : Sql dba

591

---

What is an escape character in sql?

571

---