Views for Dummies

Posted on 2008-11-11
Medium Priority
Last Modified: 2013-12-07
Can someone give me an explanation what a view does and how it works?

I have to use SQL code that was done by others and  their views are very long -- makes it confusing.
Question by:lcor
LVL 143

Accepted Solution

Guy Hengel [angelIII / a3] earned 500 total points
ID: 22931377
please start reading here:

need more clarifications?
LVL 32

Assisted Solution

awking00 earned 500 total points
ID: 22931733
Basically, a view is not much more than a memorized query that gets updated (refreshed) based on the criteria established at the time of the view's creation.
LVL 18

Assisted Solution

sventhan earned 500 total points
ID: 22940481
LVL 18

Assisted Solution

rbrooker earned 500 total points
ID: 22944798
if you have a complicated sql statement that you need to keep, turn it into a view.
SQL> select * from <view>; will then be interpreted as SQL> select * from ( really complicated sql statement );
it simplifies things for you.

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question