Answer / Akhilesh Kumar Bharti

A view is a virtual table in Oracle based on a SELECT statement. It does not store any data itself, but rather defines a result set that can be queried like a regular table. Views are useful for security purposes, as they allow administrators to limit the data visible to users, and also for complex queries, as they can simplify and optimize complex queries.

What is the difference between postgresql and oracle?

1 Answers  

---

What is bulk collect in oracle?

1 Answers  

---

What is BBED in Oracle?

1 Answers   MCN Solutions,

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

1 Answers  

---

what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?

2 Answers  

---

T1: T2 A X--- this is updated record B B like this T1 table having no.of records updated. write a query"retrive updated record from T2"

2 Answers   Cognizant,

---

what r routers?

1 Answers  

---

What is the difference between alert log file and tarce file ?

1 Answers   TCS,

---

What is merge in oracle?

1 Answers  

---

What are the oracle built-in data types?

1 Answers  

---

What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?

1 Answers   TCS,

---

How to delete a column in an existing table in oracle?

1 Answers  

---