Answer / sandip gele

In view,we can create virtual table with the columns from
different tables by relation between them, we can use this
view as a table for selecting a data but we can't use view
to insert data.

Answer / yuvaraja

SQL: VIEWS

------------------------------------------------------------
--------------------

A view is, in essence, a virtual table. It does not
physically exist. Rather, it is created by a query joining
one or more tables.

Creating a VIEW
The syntax for creating a VIEW is:

CREATE VIEW view_name AS
SELECT columns
FROM table
WHERE predicates;



For example:

CREATE VIEW sup_orders AS
SELECT suppliers.supplier_id, orders.quantity, orders.price
FROM suppliers, orders
WHERE suppliers.supplier_id = orders.supplier_id
and suppliers.supplier_name = 'IBM';

This would create a virtual table based on the result set
of the select statement. You can now query the view as
follows:

SELECT *
FROM sup_orders;



Updating a VIEW
You can update a VIEW without dropping it by using the
following syntax:

CREATE OR REPLACE VIEW view_name AS
SELECT columns
FROM table
WHERE predicates;



For example:

CREATE or REPLACE VIEW sup_orders AS
SELECT suppliers.supplier_id, orders.quantity, orders.price
FROM suppliers, orders
WHERE suppliers.supplier_id = orders.supplier_id
and suppliers.supplier_name = 'Microsoft';



Dropping a VIEW
The syntax for dropping a VIEW is:

DROP VIEW view_name;

For example:

DROP VIEW sup_orders;



Frequently Asked Questions

------------------------------------------------------------
--------------------

Question: Can you update the data in a view?

Answer: A view is created by joining one or more tables.
When you update record(s) in a view, it updates the records
in the underlying tables that make up the view.

So, yes, you can update the data in a view providing you
have the proper privileges to the underlying tables.


------------------------------------------------------------
--------------------

Question: Does the view exist if the table is dropped from
the database?

Answer: Yes, in Oracle, the view continues to exist even
after one of the tables (that the view is based on) is
dropped from the database. However, if you try to query the
view after the table has been dropped, you will receive a
message indicating that the view has errors.

If you recreate the table (that you had dropped), the view
will again be fine.

Answer / guest

If we have several tables in a db and we want to view only
specific columns from specific tables we can go for views.
It would also suffice the needs of security some times
allowing specfic users to see only specific columns based on
the permission that we can configure on the view. Views also
reduce the effort that is required for writing queries to
access specific columns every time.

Answer / prakash.s

Views are simply called as mirror table or virtual table.
Feild of one table can be updated inside the view.
Updation of more than one table inside the views is not
possible.

Answer / sachin ladda

In view,we can list out different column from different
table in one virtual table..

Answer / kalyan

A View is a named virtual table that is defined by a query
and used for a table

What is postgresql server?

0 Answers  

In which files does sql server actually store data?

0 Answers  

How to execute multiple stored procedures at one time in sql server?

0 Answers  

What is an sql server agent?

0 Answers  

how to insert the values in 5 table at a time with triggers . if u have any solution then co-operate me ?

1 Answers  

What is a non-clustered index?

0 Answers  

Can we use where clause with group by?

0 Answers  

What is the most common trace flags used with sql server?

0 Answers  

Why do we partition data?

0 Answers  

in the physical file layout, where should the transaction log be stored in relation to the data file?

0 Answers  

What is meant by indexing files?

0 Answers  

Why do we need different type of parameter?

0 Answers