Answer Posted / parna

It is an object in the database.It doesn't store any data.
It is stored as a select statement in the datadictionary
tables.This is a virtual table which do not have physical
existance only at runtime.It retrive values from one
table,if it is created only one table than DML can perform
on that table.
Operations are used in view:-Insert,Delete,Update.

How to create a stored function in oracle?

1105

---

State and explain about oracle instance?

991

---

What is oracle sid?

955

---

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

2175

---

What are the different pseudo commands? Explain in general?

1080

---

Can group functions be mixed with non-group selection fields?

1020

---

Can I create users through internet explorer in oracle 10g?

1084

---

Can we convert a date to char in oracle and if so, what would be the syntax?

1015

---

Explain an exception?

994

---

6. Display the client name and order date for all orders using the traditional method.

2306

---

What is merge in oracle?

1054

---

What is an oracle user role?

984

---

Why do we need integrity constraints in a database?

1020

---

Is oracle a programming language?

985

---

How to use subqueries in the from clause in oracle?

1112

---