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;

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1633

---

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

950

---

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2168

---

Is rowid unique in oracle?

980

---

How to turn on or off recycle bin for the instance?

1053

---

What is a private synonym?

1562

---

State and explain the different types of data models?

925

---

How do I find my oracle client driver version?

1020

---

What is bind variable in oracle 11g?

1025

---

What are the different types of partitions in oracle?

951

---

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2016

---

How to upsert (update or insert into a table)?

986

---

How to invoke the data pump import utility?

1143

---

does the query needs a hint to access a materialized view?

1845

---

How many types of synonyms in Oracle?

1104

---