Home » Other » Training & Certification » View & Materialized View & Database
icon5.gif  View & Materialized View & Database [message #255859] Thu, 02 August 2007 03:02 Go to next message
prachi.mgorwadkar
Messages: 75
Registered: May 2007
Location: Pune
Member
Can anyone tel me the exact difference between View & Materialized View & Database.

As per my knowledge,

View has a virtual storage. Are used for security purpose,
like to view only the data from table to which users have permission to access.
Can we use Views over Remote databases?

Materialized View gets actually stored in the database.
These are generally used for Remote databases.
Does it's refresh action is advantageous for their use over view.

Database is a huge collection or storage of data.

When to use Views & when to use MV?

Thanks in advance,
Regards,
Prachi

Report message to a moderator

Re: View & Materialized View & Database [message #255863 is a reply to message #255859] Thu, 02 August 2007 03:10 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Just like Michel once said, "what is the difference between car and a boat"? It would take too much time and space for someone to explain it. That's why Documentation exists; read it, learn every term you are interested in and then you'll be able to tell the difference by yourself.

Report message to a moderator

Re: View & Materialized View & Database [message #255866 is a reply to message #255863] Thu, 02 August 2007 03:26 Go to previous messageGo to next message
prachi.mgorwadkar
Messages: 75
Registered: May 2007
Location: Pune
Member
Thanks for the reply.

I will do that.

Prachi

Report message to a moderator

Re: View & Materialized View & Database [message #255983 is a reply to message #255866] Thu, 02 August 2007 11:06 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
"what is the difference between car and a boat"?


Car has 4 TIRES Boat got none Wink Razz

Report message to a moderator

Re: View & Materialized View & Database [message #256010 is a reply to message #255983] Thu, 02 August 2007 14:02 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In my country, boats do have tyres. How many? It depends on boat size.

/forum/fa/2813/0/

Report message to a moderator

Re: View & Materialized View & Database [message #256011 is a reply to message #256010] Thu, 02 August 2007 14:09 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Laughing

Report message to a moderator

Re: View & Materialized View & Database [message #256014 is a reply to message #255983] Thu, 02 August 2007 14:17 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
DreamzZ wrote on Thu, 02 August 2007 18:06
Quote:
"what is the difference between car and a boat"?


Car has 4 TIRES Boat got none Wink Razz

So, basically you say "Take the tires of your car and you have a boat"

Report message to a moderator

Re: View & Materialized View & Database [message #256018 is a reply to message #256010] Thu, 02 August 2007 14:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Laughing

Report message to a moderator

Re: View & Materialized View & Database [message #256019 is a reply to message #256014] Thu, 02 August 2007 14:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Laughing Laughing

Report message to a moderator

Re: View & Materialized View & Database [message #256023 is a reply to message #256019] Thu, 02 August 2007 14:48 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Embarassed

Report message to a moderator

Previous Topic: OCA?
Next Topic: 1Z0-042 Exam
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 24 06:27:23 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.