Answer Posted / o.nagamani

View is a virtual storage of the original table.It is the
one kind of data hiding.

Advantages of View:
1. Restrict Data Access and/or simplify data access.
2. Simplify Data manipulation.
3. Import and Export data.
4. Merge Data.

Explain the use of file option in exp command.

593

---

How to assign data of the deleted row to variables?

577

---

Why does Oracle not permit the use of PCTUSED with indexes?

1945

---

Oracle

1837

---

What do you mean by a database transaction & what all tcl statements are available in oracle?

544

---

---

What is a named program unit?

576

---

What are the limitations oracle database 10g xe?

566

---

Can we convert a date to char in oracle and if so, what would be the syntax?

546

---

What is an oracle function?

589

---

What is redo log?

618

---

When do you get a .pll extension in oracle?

671

---

How do we get field details of a table?

541

---

How to select some columns from a table in oracle?

545

---

how can we store any pdf file in oracle

1631

---

How do I learn what codesets are available in oracle?

570

---