Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Common StatementsRSS Feeds

CREATE VIEW

Posted By: Barrett Schmidt     Category: Oracle     Views: 5669

CREATE VIEW with example.

CREATE VIEW

CREATE VIEW <view_name> [(column1, column2...)] AS
SELECT <table_name column_names>
FROM <table_name>

using the CREATE VIEW statement. After a view is created, it can be queried and data within the view can be modified. 

  
Share: 

 
 
 

Didn't find what you were looking for? Find more on CREATE VIEW Or get search suggestion and latest updates.

Barrett Schmidt
Barrett Schmidt author of CREATE VIEW is from Frankfurt, Germany.
 
View All Articles

 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!