![]() |
|||
|
![]() |
||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
![]() |
|
Looking for the original pages? (formerly called "Morgan's Library") You can find them here.
![]() Term: VIEW
Definition: CREATE OR REPLACE VIEW <view_name> AS Example Usage: CREATE VIEW sales_map 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 Links: Related Code Snippets:
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us | 33 users online © 2009 psoug.org |