A table contains data, a view is just a SELECT statement which has been saved in the database (more or less, depending on your database).The advantage of a view is that it can join data from several tables this creating a new view of it. Say you have a database with salaries and you need to do some complex statistical queries on it.Instead of sending the complex query to the database all the time, you can save the query as a view and then SELECT * FROM view

Views are virtual tables which hold the data from one or more tables. It is stored in database. View does not contain its self any data, it is a set of queries that are applied to one or more tables that is stored within the database as an object. Where as Table are stored physically in database that contain rows and columns, columns representing

Table is a basic unit of data storage in an oracle database. It holds all user accessible data.View is a virtual table - It can be created on a table or another view. - It is just like a window through which we can access or change base table data. - It does contain data of its own. It always takes data from its base table. - It is stored as a query in data dictionary.Whenever you query a view it gets data from its based table using this query.Main advantage of using views - You can ristrict access to predetermined set of rows and columns of a table - You can hide complexity of query - You can hide complexity of calculationSynonym is alternate name given to table, view, sequence or program unit. -It is used to mask real name and owner of the object. - You can provide public access to tables by creating public synonymns.

tables contains records with data. Views are looking as table query. For example: if u wish to show only last 5 rows in a table, you can create a view ( for example 'view1' ) with query as below:select top 5 * from table order by id descAlways you like to show last 5 records, you can open the view. Also you can treat the view as table, so you can query to views created before. For example:select top 2 * from view1

Set of rows/columns is table if we want to view a duplicate copy of column name that is a view

Table is collection of data which contain Column and row. View is a virtual table which use to create web API.

Table is collection of data which contain Column and row. View is a virtual table which use to create web API.

1>table can create individually but view can not create individually view depends one table or more than one table 2> table can call compile time and run time data and view can call only run time 3>table is performance wise slower and view is faster

Table is collection of data which contain Column and row. View is a virtual table which use to create web API.

view is a virtual table based on the result-set of an SQL statement.A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database.TABLE is a normal real time table which really hold data in the database.

A table contains data, a view is just a SELECT statement which has been saved in the database (more or less, depending on your database).

Table is an object of an database which contains data inside. where as views are used to retrieve data from table or to display data in such manner.we can use select , insert update and delete operation in table but in view only select

A table contains data, a view is just a SELECT statement which has been saved in the database (more or less, depending on your database). The advantage of a view is that it can join data from several tables this creating a new view of it. Say you have a database with salaries and you need to do some complex statistical queries on it. Instead of sending the complex query to the database all the time, you can save the query as a view and then SELECT * FROM view

table contains data of same record but view can be said as virtual table can contain data from different table table same syntax of Select use for selction

Table is an object of an database which contains data inside. where as views are used to retrieve data from table or to display data in such manner.

Table is a simple representation of out entity but view is virtual table that can contain data from different tables

Tables are the primary source to feed data, views are virtual tables created on tables, views are mainly used to restrict the data to display.

-->It's a virtual table. -->Stores the data more than one tables information as columns. -->Insertion into views will effect the main table.

we can say view can be virtual table and it can be handle to a table without any where clause in the query of view.

Table - It has to be physically existence in database with rows and columns.View - It has to be logically/virtually existence in database with rows and columns.

Table & view both having row-column format but difference is that table having physical data where as view not.

Table comprises of rows and columns, columns representing fields and rows containing the data or records. View is a imaginay table which contains data at run time.

table is a collection of rows and columns but view is a virtual table like a table that contain rows and columns but does't contain any type of data in it