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

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
rleishman
Messages: 3724
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: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OracleŽ Database Concepts
Chapter 5 Schema Objects
Section Overview of Views

Regards
Michel
Previous Topic: list dates from <some date> to sysdate
Next Topic: How to get output for procedure using optional parameter and ref cursor
Goto Forum:
  


Current Time: Sat Dec 03 22:14:27 CST 2016

Total time taken to generate the page: 0.11732 seconds