Home » Other » Training & Certification » views and corelated queries (oracle 9i)
views and corelated queries [message #313890] Tue, 15 April 2008 01:18 Go to next message
sharathmpatil
Messages: 38
Registered: February 2008
Location: Bangalore
Member

HI,

1) Which is the scenario where views could be useful?

2) which is the scenario where u can use corelated subquery?

Thanks in advance
Re: views and corelated queries [message #313897 is a reply to message #313890] Tue, 15 April 2008 01:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This kind of post must be posted in Homework, Training & Certification forum.

Regards
Michel
Re: views and corelated queries [message #313927 is a reply to message #313890] Tue, 15 April 2008 03:32 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
These are interview questions right?

The whole idea of these types of questions is NOT to learn the answer to them by heart. The idea is that you learn about (for example) views, so you can come up with the answer by yourself, based on what you know and understand about the topic.
Previous Topic: recovery faq
Next Topic: Stored Procedure
Goto Forum:
  


Current Time: Fri Dec 02 18:57:42 CST 2016

Total time taken to generate the page: 0.27194 seconds