What is an Oracle view?

Answer Posted / nishi

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.)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is data block in Oracle?

615


Will you be able to store pictures in the database?explain.

535


How to install oracle database 10g xe?

560


What is a static data dictionary in oracle?

564


Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

1771






What is the difference between substr and instr?

517


 How to use an oracle sequence generator in a mapping?

559


Can multiple cursors being opened at the same time?

605


I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

620


How to pass parameters to procedures in oracle?

566


How can I create database in oracle?

563


What is rich query?

539


What is an oracle transaction?

582


How do I escape a reserved word in oracle?

624


How to create a temporary table in oracle?

687