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 rename an existing table?

1048

---

Can you assign multiple query result rows to a variable?

926

---

How to convert characters to numbers in oracle?

997

---

What are the ways tablespaces can be managed and how do they differ?

2267

---

How to rename a column in an existing table?

971

---

Explain the use of rows option in imp command.

1040

---

How remove data files before opening a database?

996

---

Can we commit inside a function in oracle?

916

---

How to load a large xml file?

1001

---

How to connect to a remote server?

1050

---

what is meant by magic query

2133

---

What are group functions in oracle?

965

---

What is primefaces used for?

1005

---

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5329

---

Can a formula column be obtained through a select statement ?

2262

---