GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  Database Administration
Go To First  |  Previous Question  |  Next Question 
 Database Administration  |  Question 10 of 231    Print  
What is an Oracle view

  
Total Answers and Comments: 4 Last Update: July 09, 2005   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
April 06, 2005 13:08:06   #1  
Karthikeyan.M        

RE: What is an Oracle view
A view is a logical table which makes a
complex query easy.We can even create
a complex view by joining two tables.

 
Is this answer useful? Yes | No
May 30, 2005 02:26:13   #2  
priya        

RE: What is an Oracle view
it is the logical view of the database object
 
Is this answer useful? Yes | No
June 18, 2005 00:33:11   #3  
soccer_champ        

RE: What is an Oracle view
A view is a logical table based on a table or another view. It can be created using more than one table or view also.
 
Is this answer useful? Yes | No
July 09, 2005 08:01:35   #4  
Ramu DBA        

RE: What is an Oracle view
A view is a named query. It is a tailored presentation of the data contained in one or more tables (or other views).

For SQL view a named or derived virtual table
For users view a table (which in fact does not exist!)
View a separate copy of an underlying table
View a window into the underlying table
Changes can be done from both directions:
underlying table view

Views are created dropped or granted access to identical to a table.

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape