Answer Posted / kumar

View can be updated ...but some restrictions are there.

Let us think we are using one or more tables to create a
view and if the view contains all the NOT NULL constraint
columns of the tables, then only we can update the view or
else we can't.

When do you get a .pll extension in oracle?

1125

---

What is the difference between formal parameters and actual parameters?

1059

---

Whats the benefit of dbms_stats over analyze?

1979

---

How do I spool to a csv formatted file using sqlplus?

1004

---

How to convert raw data type into text in oracle? Explain

975

---

Why should I use oracle database?

974

---

What are the roles of dba?

1050

---

What do you understand by a database object?

1038

---

Explain oracle left join with an example?

983

---

Explain implicit cursor.

998

---

Explain the use of inctype option in exp command.

1012

---

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

1103

---

What do you mean by redo log file mirroring?

1008

---

What is an oracle wallet?

923

---

what's query optimization and without use of IN AND Exist can we get another way data from query

2116

---