GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  SQL Plus
Go To First  |  Previous Question  |  Next Question 
 SQL Plus  |  Question 91 of 132    Print  
If a View on a single base table is manipulated will the changes be reflected on the base table ?
If changes are made to the tables which are base tables of a view will the changes be reference on the view.


  
Total Answers and Comments: 6 Last Update: March 25, 2007   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
August 24, 2005 21:05:05   #1  
suresh        

RE: If a View on a single base table is manipulated will the changes be reflected on the base table...
If we do some modificatios on base table those changes will be displayed in existing view or not?
 
Is this answer useful? Yes | No
November 27, 2005 00:09:21   #2  
pooja        

RE: If a View on a single base table is manipulat...

if view on based on a single table then u can execute any DML directly on it and can see the changes in the base table

and ifview is based on join of 2 tables then only one base table can be modified at one time so in order to make changes in both the tables use insted of triggers


 
Is this answer useful? Yes | No
January 02, 2006 08:10:53   #3  
Ravindra wadalkar        

RE: If a View on a single base table is manipulat...
Yes it will be reflected
 
Is this answer useful? Yes | No
October 24, 2006 14:12:38   #4  
vijay saxena        

RE: If a View on a single base table is manipulat...

if the reference to the base table is made then any changes will also affected in base table respect to view table.


 
Is this answer useful? Yes | No
March 11, 2007 03:29:40   #5  
rayadurgamsudha Member Since: March 2007   Contribution: 6    

RE: If a View on a single base table is manipulat...

yes the changes can be viewed in the base table if and only if the view is on a single base table.


 
Is this answer useful? Yes | No
March 25, 2007 13:05:26   #6  
Bharath kumar        

RE: If a View on a single base table is manipulat...

Hi

1) View is like getting information from many tables and displaying the result to the user.
2) If the view is modified it does not effect the base table.
3) If the base tables are modified then it will effect the views it depends on what changes have you performed in the base tabe like dropping columns etc..


 
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