Answer Posted / nivedita

view is a virtual table.view does not contain any data
while material view has its own data.material views are the
local copies of remote data.

Is there any restriction on the use of union in embedded sql?

667

---

What is oracle sql developer?

603

---

How can you save or place your msg in a table?

520

---

Describe types of sql statements?

543

---

how to calculate the difference between two dates? : Sql dba

543

---

---

What is package in pl sql with an examples?

543

---

What is an inconsistent dependency?

579

---

How many commands are in sql?

521

---

What is the basic structure of an sql?

567

---

What is scalar function?

564

---

Can we use ddl commands in pl sql?

554

---

What is a stored procedure in sql with example?

598

---

Can we call stored procedure in function?

546

---

What is meaning of <> in sql?

581

---

what is a primary key? : Sql dba

552

---