| |
GeekInterview.com > Interview Questions > Oracle > SQL
| Print | |
Question: View - Base Tables
Answer: Does View occupy memory? If we delete the base table of existing view, What happens? |
| October 10, 2009 01:45:09 |
#7 |
| Rabindra_Kumar |
Member Since: October 2009 Total Comments: 6 |
RE: View - Base Tables
|
Actually view is a stored select statement and its code is stored in data dictionary. It doesn't occupy space in the memory. whenever view is called, the stored select statement executes and fetches the data from the base table.
If base table is deleted, view becomes invalid. |
| |
Back To Question | |
