Discussion :: Introduction to SQL - General Questions (Q.No.6)
|Smita said: (Jun 4, 2011)|
|What is virtual table?|
|Siva said: (Jul 5, 2011)|
|A virtual table is temporary changes in a main database table.|
|Ritu said: (Jul 21, 2011)|
|Can you explain what is virtual table ?|
|Mini said: (Jul 30, 2011)|
|Virtual table is a temporary which is been viewed by us through the sql commands.
Ex: SELECT *...
|Shobhit said: (Aug 30, 2011)|
|Instead putting the whole db into main memory sql engine provides required rows and columns that is called vrtual table.|
|Ruthvik said: (Aug 31, 2011)|
|YA virtual table is a temparory table that can be only viewed by using commands, that means we can't alter that table by view command.|
|Manche Shekhar said: (Nov 8, 2011)|
|View is virtual database table, we can retrive the data from view by using sql commands.
By using view we can provide confidential to our data.
|Kethes said: (Jan 27, 2012)|
|Briefly explain what is a virtual?|
|Mvp said: (Jan 30, 2012)|
|A view is a virtual table which means, whose rows are not explicitly stored in the database but computed as needed.
For ex: Consider a student and course relations. Suppose we are often interested in finding the names of students who have joined in a particular course, we can define a view for this purpose
CREATE VIEW myview (name, sid, course)
AS SELECT S.sname, S.sid, C.course
FROM student S, course C;
|Kishore said: (Jul 9, 2013)|
|View doesn't occupies space it is logical just like a window.|
|Mithilesh Kumar said: (Jul 22, 2013)|
|There are two types of view:-
A) Simple view.
B) Complex view.
*Create view view_name
AS select * from table name where condition;
*Create view view_name (list of column names)
As write query.
Simple view:- It supports DML operation.
Complex view:- It does not support DML operation.
|Arati Sharma said: (Jul 31, 2013)|
|A view always shows up-to-date data! The database engine recreates the data, using the view's SQL statement, every time a user queries a view.|
|Jeet said: (Aug 13, 2013)|
|Virtual table is a table which does not occupy any space it link with main table. Which is create by view, we can perform any select statement on virtual table.|
|Ramhari Phatangare said: (Aug 31, 2013)|
|Virtual tables can have indices but that must be built into the virtual table implementation. They cannot be added separately using CREATE INDEX statements.|
|Abhigyan said: (Jan 9, 2014)|
|A view is a named table that is represented, not by its own physically separate stored data, but by its definition in terms of other named tables (base tables or views).|
|Rahul Jain said: (Apr 3, 2014)|
|Its said as virtual table because it physically doesn't exist only the sql syntax which creates the virtual table is stored in the database. When the sql query is rendered at that time system creates a view of that table it is more secure than the direct accessible physical tables.|
|Rahul Bajaj said: (Nov 8, 2014)|
|When any information changes in view does it get reflected in base table.
Can we change info in view and make the change in main base table also?
Will you please explain it in detail?
|Jayati Nayak said: (Feb 18, 2015)|
|View can be of two categories:
1. Simple view.
2. Complex view.
We can restrict the dml's to be perform on the view using with read only option.
SQL> create view mvu as select empno, ename, sal, deptno from emp;
|Mitali said: (Mar 17, 2016)|
|If we delete some info in virtual table will it also get deleted from base table?|
|Melese Alemante said: (May 15, 2016)|
|Views can represent a subset of the data contained in a table. Consequently, a view can limit the degree of exposure of the underlying tables to the outer world: a given user may have permission to query the view while denied access to the rest of the base table.
Views can join and simplify multiple tables into a single virtual table.
Views can act as aggregated tables, where the database engine aggregates data (sum, average, etc. ) and presents the calculated results as part of the data.
Views can hide the complexity of data. For example, a view could appear as Sales2000 or Sales2001, transparently partitioning the actual underlying table.
Views take very little space to store; the database contains only the definition of a view, not a copy of all the data that it presents.
Depending on the SQL engine used, views can provide extra security.
Post your comments here:
Email : (optional)
» Your comments will be displayed only after manual approval.