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

How to execute a stored program unit?

791


How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1694


What is memory advisor in Oracle?

814


What happens to the data files if a tablespace is dropped?

795


What is a read only transaction in oracle?

801


11. Display the client number and name and the client number and name of the person who referred that client.

2089


How view is different from a table?

799


What are the differences between interval year to month and interval day to second?

762


How to use an explicit cursor without open statements?

809


How to define a data source name (dsn) in odbc manager?

754


what is the scripts in data base?

1831


How can I combine multiple rows into a comma-delimited list in oracle?

793


What is a schema in oracle?

759


How many categories of data types?

755


What are ddl statements in oracle?

770