Difference between Table and Views ?

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

Mahesh Gawhane

10y

4

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

Pankaj Kumar Choudhary

10y

3

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.

Sofique Uddin

8y

2

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

Irdi Buzali

9y

2

Data Visibility:

Table: When testing tables, you directly access and manipulate the actual data stored in the table. You can perform CRUD operations (Create, Read, Update, Delete) on the table’s data.
View: When testing views, you interact with the data presented by the view rather than the underlying tables. Views act as a filtered or transformed representation of the data, so you need to ensure that the view correctly displays the expected data based on the underlying tables.
Data Modification:

Table: As a tester, you may need to perform data modifications during testing, such as inserting test data, updating records, or deleting data. Tables allow you to directly perform these modifications.
View: Views are generally read-only, which means you cannot directly modify the data through a view. If you need to modify the data, you would need to identify the underlying table(s) associated with the view and perform the necessary modifications on the table(s).
Data Validation:

Table: When testing tables, you can verify the data integrity and consistency by comparing the actual data in the table with expected values or predefined business rules. You can also validate constraints and relationships defined on the table.
View: Testing views involves ensuring that the data presented by the view is accurate and aligned with the expected results based on the underlying tables and any filtering or transformation logic applied in the view’s definition.
Query Testing:

Table: When testing tables, you may need to write and execute SQL queries directly on the table to fetch specific data for testing purposes or to validate complex business scenarios.
View: Testing views involves writing and executing SQL queries against the view to validate the correctness of the view’s logic, data filtering, or transformation. You need to ensure that the query results from the view align with the expected results.

Deepak Rawat

2y

1

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

Venkateswaran S

8y

1

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

Keerthi Venkatesan

9y

1

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

Sandeep Kumar

9y

1

The main difference between view and table is that view is a virtual table based on the result set of an SQL statement, while the table is a database object which consists of rows and columns that store data of a database. In brief, a programmer cannot create views without using table.

steps in a wrongful death lawsuit

Jez Supreme

3y

0

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

Sanjeev Kumar

9y

0

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

Keerthi Venkatesan

9y

0

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.

Nikhil Sangani

9y

0

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).

Bhuvanesh Mohankumar

9y

0

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

Ashish Srivastava

9y

0

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

Kml Surani

9y

0

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

Ayyaz Ahmad

9y

0

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.

Chinmaya Dash

10y

0

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

Ayyaz Ahmad

10y

0

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.

Ramakrishna Basagalla

10y

0

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

Sreekanth Reddy

10y

0

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.

Bhushan Bhasme

10y

0

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.

Sudheshwer Rai

10y

0

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

Sujeet Suman

10y

0

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.

Munesh Sharma

10y

0

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

Sonia Chugh

10y

0

Insert Link

Embed YouTube Video

Table Options

Insert Image