Views for Dummies

Posted on 2008-11-11
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 142

    Accepted Solution

    please start reading here:

    need more clarifications?
    LVL 31

    Assisted Solution

    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

    LVL 18

    Assisted Solution

    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

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    oracle global variables 4 36
    Access Webapp: Table to Query to Table 14 36
    oracle query help 29 48
    SQL Round a percentage 2 15
    How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
    This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
    This video shows how to recover a database from a user managed backup

    729 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now