With Oracle views are generally created for one of two reasons Simplify the data accesses to tables.
Views are what they sound like, they provide a particular view of the data.
Enter the follow script into your sqlplus session or cut and paste. If we wanted to find out who our postgraduate students are, i.e. those who have already graduated then we could enter the following script. But that involves the user in knowing how a person is determined as a graduate. Now lets create a view called postgrads. We only want to see and access those students who are graduates.