Home » SQL & PL/SQL » SQL & PL/SQL » Views:advantages
Views:advantages [message #319534] Mon, 12 May 2008 02:11 Go to next message
Messages: 27
Registered: April 2008
Junior Member

I'm studying the book "Begining Oracle Programming" and in the overview section of Views, it says:
a view can be used to:

  • Enforce security
  • Enhance performance
  • Hide complexity
  • Provide abstraction
  • Customize presentation of data

Actually i couldn't understand what means "Customize presentation of data" ,"Enforce security" and "Enhance performance"... how can Views provide these? May someone give some information about these?
Thanks in advance.
Re: Views:advantages [message #319538 is a reply to message #319534] Mon, 12 May 2008 02:22 Go to previous messageGo to next message
Messages: 3727
Registered: October 2005
Location: Melbourne, Australia
Senior Member
If I don't want you to see a particular column, then I create a view that excludes it and only give you access to that view - not the table. The same can be done with rows that you want to protect.

Enhance performance is a bit rich. There's nothing you can do to enhance performance in a view that you cannot do in a SQL.

Customise presentation of data:
CREATE VIEW customer_fullname AS
SELECT id, surname || ', ' || firstname
FROM   customer

Ross Leishman
Re: Views:advantages [message #319539 is a reply to message #319534] Mon, 12 May 2008 02:24 Go to previous message
Michel Cadot
Messages: 65153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OracleŽ Database Concepts
Chapter 5 Schema Objects
Section Overview of Views

Previous Topic: Merging multiple rows into single row
Next Topic: How to get output for procedure using optional parameter and ref cursor
Goto Forum:

Current Time: Tue Aug 22 07:58:16 CDT 2017

Total time taken to generate the page: 0.04780 seconds