This command creates a new view called "sales_map". Creating a view doesn't result in anything being stored in the database except for a data dictionary definition that contains the view parameters.
Views are frequently used to hide the tables that contain the actual data that is queried. As a low-level form of security, views can be used to restrict the columns that a particular user has access to.
You may want to visit the Oracle CREATE_VIEW Statement page for additional syntax and examples on views.
Related Code Snippets:
|© 2003 - 2024 psoug.org