Call for Oracle support & training (800) 766-1884
Free Oracle Tips

Corporate Oracle Training
Custom Oracle Training
Oracle New Features Training
Advanced Oracle DBA Classes
Oracle Tuning Courses
Oracle Tips & Tricks
Oracle Training Links
Oracle Training Links
Oracle Training Links

We are top for USA Oracle Training Clients


Free Oracle Tips


Free Oracle App Server Tips


Oracle support

Oracle training

Oracle tuning


Remote Oracle

Custom Oracle Training


  Oracle Tips by Burleson

Chapter 2 Introducti

on to Oracle Security

Column Description

– Note how the column PROCEDURE_DESCRIPTION is used after the lengthy clause. When the user selects all the columns from the view, this is displayed as the column name.

Storage Savings

– A view is not actually stored with its data, unlike a table. It's nothing but a stored query. Therefore as many views as necessary can be created without consuming space.

There is another concept in Oracle called a Materialized View, also known as a Snapshot. This is not a conventional view because the data from the query is actually stored in the object, or the data from the execution of the query is materialized in the database, and hence the term, materialized view.

This takes care of reading data, but what about modifying it? Can we modify a view directly and ensure that only the authorized data is modified, not all the rows of the table? Yes, we can. The above view, known as one of the simple view types, can be inserted, updated, or deleted directly just like a table, and only the rows that would have been retrieved by the table are affected, not all rows. If the view is complex, and the definition of complex views varies based on context, it may not be directly manipulated. In that case, the view can be manipulated using a special type of trigger known as Instead of Triggers. These triggers are defined on the view, but instead of acting on that view, they can be directed to act on the underlying table.

Use of Views can hide specific details of the table row, especially the sensitive data such as Protected Health Information, without creating additional storage needs.

The above text is an excerpt from:

Oracle Privacy Security Auditing

The Final Word on Oracle Security


This is the only authoritative book on Oracle Security, Oracle Privacy, and Oracle Auditing written by two of the world’s leading Oracle Security experts.

This indispensable book is only


 and has an immediate download of working security scripts:


Oracle performance tuning book



Oracle performance tuning software

Oracle performance tuning software
Oracle performance Tuning 10g reference poster
Oracle training in Linux commands
Oracle training Excel


email BC:

Copyright © 1996 -  2014 by Burleson Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.