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 $oracle_base and $oracle_home?

1052

---

What do you mean by merge in oracle and how can you merge two tables?

926

---

What are internal user account in oracle?

960

---

In the oracle version 9.3.0.5.0, what does each number shows?

1249

---

How to pass parameters to procedures in oracle?

1012

---

What is concurrency in oracle?

967

---

What is object data modeling?

916

---

How to best split csv strings in oracle 9i?

1003

---

How to use "out" parameter properly?

1040

---

What is the data type of dual table?

939

---

How to write a query with a left outer join in oracle?

1019

---

What is Java Pool in Oracle?

1112

---

Explain the blob datatype?

1035

---

What is the difference between 10g OEM and 11g OEM?

936

---

What's dateware house and what's clustor with practicle example

2145

---