Answered Questions
Asked By: manu4sql
| Asked On: Oct 23rd, 2008
Does view occupy memory? If we delete the base table of existing view, what happens?
Asked By: shamim909
| Asked On: Oct 17th, 2006
Answered by: todeepakmalhotra on: Nov 10th, 2008
You cannot use the database name before the table name like db1.t1.we can only use a user name and then table name. eg. let we have a user "deepak" then we can write select * from deepak.t1 . We ca...
Answered by: oozaifa on: Nov 6th, 2008
Type schema name before table name or your id dont have the access to view the data from that table
Asked By: Interview Candidate
| Asked On: Jun 1st, 2005
Answered by: SHIMAR on: Apr 16th, 2012
DDL is used to create, alter and truncate
DML is used to insert, update, delete and drop
Answered by: Venki on: Dec 19th, 2011
DDL means "Data Definition Language". SELECT, UPDATE, INSERT belong to DML, which is "Data Modification Language". DDL is all the other commands -- for example, CREATE TABLE.
User Panel
Categories
Interview Coaching
Interview Question
Career Counselling
Copyright © 2013 GeekInterview.com | All Rights Reserved
NH
NH
Editorial / Best Answer
Answered by: Mad Hatter
View all answers by Mad Hatter
Member Since Nov-2008 | Answered On : Nov 4th, 2008
View does not occupy memory, but Oracle keeps view code in its dictionary (you can check in user_views, for example)
If you delete the base table, the view becomes INVALID.
In order to make it valid again, you have to ether build the deleted table again, or create anotehr view with the same name and structure as deleted table, or create synonym with the same name as deleted table, which will point to the table with the same structure.
Views are database objects - they are just SQL code stored in database which will be executed every single time the view is called. Database will check the existance of columns and tables in the base ...
View does not occupy memory as it only provides a way for watching multiple views of an object: Table. Moreover, it is a virtual table which does not take space.It provides DATA HIDING.For e.g. i...