A view is a virtual table.
A view can be created based on two or more tables.
What ever data is present in the view cannot be modified. but you run queries on it .
syntax:
create view "view name" as SELECT column1, column2, column3..... FROM table_name WHERE "condition";
A view can be created based on two or more tables.
What ever data is present in the view cannot be modified. but you run queries on it .
syntax:
create view "view name" as SELECT column1, column2, column3..... FROM table_name WHERE "condition";
No comments:
Post a Comment