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;

How to get a list of all background sessions in the database?

1035

---

How many categories of data types?

1038

---

What are the major difference between truncate and delete?

1130

---

What is tns service name?

1177

---

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2165

---

What is a data lock in oracle?

1178

---

State all possible different index configurations a table can possibly have?

1094

---

What is merge statement used for?

1071

---

What is translate in oracle?

1140

---

What is the usage of analyze command in oracle?

1138

---

Is oracle an open source?

1121

---

Explain coalesce function?

1246

---

What is the relation of a user account and a schema?

1173

---

What are advantages of dateset in datastage?

2304

---

What are the differences between date and timestamp in oracle?

1093

---