View syntax in SQL


VIEW is a virtual table, through which a selective portion of the data from one or more tables.
It is used to make the complex query in easy format. You make the view for complex query fetching data for reports function in Oracle.


CREATE VIEW view_name
SELECT column_list FROM table_name [WHERE condition];


CREATE VIEW view_product
AS SELECT product_id, product_name FROM product;


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.