What is Materialized View? In What Scenario we Use Materialized View?

2 Answers   Dinesh, Marlabs,

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

0 Answers   CTS,

---

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

0 Answers  

---

function can return multiple value?how give give sample coding

2 Answers   3i Infotech, CTS, Excelity Global, UHG,

---

Can we use pl sql in mysql?

0 Answers  

---

---

What is input buffer in sql*plus?

0 Answers  

---

can we delete the trigger in a view? if yes why if not why?

5 Answers   Tech Mahindra,

---

Can a view be mutating? If yes, then how?

0 Answers  

---

What is rollback?

0 Answers  

---

explain the options of myisamchk to improve the performance of a table. : Sql dba

0 Answers  

---

Can we use rowid as primary key?

0 Answers  

---

What is the use of sqlerrd 3?

0 Answers  

---