« Technical Interview & Viva Questions : KyaPoocha.com home page
« What is the User named Editor?
How do you debug an ASP.NET Web application »



What is an Oracle view ?


A view is a virtual table. Every view has a query attached to it. (The query is a SELECT statement that identifies the columns and rows of the table(s) the view uses.)



Explore posts in the same categories: Oracle Interview Questions


BOOKMARK THIS : del.icio.us | Digg it | Furl | reddit |

Related Questions :

  • What are the performance benefits for using Indexed views ?
    • Views in SQL Server 2000 are very similar to those in previous versions with a few major exceptions when using...
  • How would you execute a SQL query in Oracle 8 ?
    • Again, if you ever worked with Oracle, this question should be trivial for you to answer (from command prompt, of...
  • If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
    • No.  The table and its view are created anew, but the programs accessing the view do not need to be...
  • How do you call other Oracle Products from Oracle Forms?
    • Run_product is a built-in, Used to invoke one of the supported oracle tools products and specifies the name of the...
  • What is view? Different types of view.
    • View - A view is a virtual table containing fields from one or more tables. A virtual table that does...
  • What is an Oracle Instance?
    • The Oracle system processes, also known as Oracle background processes, provide functions for the user processes—functions that would otherwise be...
  • What is the difference between Oracle and SQL Server ?
    • Often people in newsgroups ask about some comparison of Oracle and SQL Server. In the article below, you can find...
  • What is Oracle Block? Can two Oracle Blocks have the same address?
    • Oracle "formats" the database files into a number of Oracle blocks when they are first created—making it easier for the...
  • What is an Oracle Instance?
    • The Oracle system processes, also known as Oracle background processes, provide functions for the user processes—functions that would otherwise be...
  • Can a view be updated/inserted/deleted? If Yes - under what conditions?
    • A View can be updated/deleted/inserted if it has only one base table if the view is based on columns from...

    Comments are closed.