Answer Posted / velmurugan uk
Materialised view is a snopshot/Copy of data(where data can
come out of select query) which can be refresed over a
period of time.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Why does for update in oracle 8 cause an ora-01002 error?
How to start a new transaction in oracle?
How to delete all rows a table in oracle?
How to retrieve data from an explicit cursor?
Explain the use of log option in exp command.
Explain the use of rows option in imp command.
How to filter out duplications in the returning rows using oracle?
How to export several tables together?
What do you mean by a database transaction & what all tcl statements are available in oracle?
What is dual table oracle?
Explain the use of owner option in exp command.
What does sharding mean?
What is dynamic proxy?
Which is better Oracle or MS SQL? Why?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)