Answer Posted / sunil maurya

A view is simply the representation of a SQL statement that
is stored in memory so that it can easily be re-used. For
example, if we frequently issue the following query

SELECT empid FROM emp;

I might well want to make this a view (the reality is that
we would probably never create a view for a statement this
simple but we wanted to use an easy example).

To create a view use the create view command as seen in this
example
CREATE VIEW view_emp
AS
SELECT empid FROM emp;

What is the difference between view and materialized view in Oracle?

1152

---

What is oracle server autotrace in oracle?

1166

---

What happens if you set the sga too low in oracle?

1147

---

Is rowid unique in oracle?

998

---

What is the exact use of Collections?

2143

---

Explain how you would restore a database using RMAN to Point in Time?

2144

---

What is oracle used for?

1026

---

What privilege is needed for a user to create views in oracle?

1044

---

What is hash cluster in oracle?

1173

---

How can I create database in oracle?

1023

---

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1846

---

State some uses of redo log files?

1006

---

How to do paging with oracle?

997

---

How do I uninstall oracle 11g?

1117

---

How to select some rows from a table in oracle?

1077

---