View - base tables
Does view occupy memory? If we delete the base table of existing view, what happens?
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...
Suppose, i've created a new database db1 n i've created a table db1.T1.Now, desc t1 --> desplaying the table structure butselect * from db1.T1 ---->giving--> table or view does not exist.. Can any one...
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...
Type schema name before table name or your id dont have the access to view the data from that table
What is DDL, dml?
DDL is used to create, alter and truncate
DML is used to insert, update, delete and drop
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.
Do you find yourself busy most of the time? Why?
Careers and Higher Education Options for BBA Graduates
Importance of an MBA for an entrepreneur
How to handle academic gap while applying for a job?
Describe a time when you had to listen to someone.
Have you experienced being given too many tasks?
What are my options when I do not get a job after graduation?
Have you gone above and beyond your job description?
Tell me about a skill you recently acquired or improved.
Has there been a time when you were presented a problem and solved it?
Ask Interview Question?
Have Career Question?
Ask Only Career questions.