what is view?

Answer Posted / parna

It is an object in the database.It doesn't store any data.
It is stored as a select statement in the datadictionary
tables.This is a virtual table which do not have physical
existance only at runtime.It retrive values from one
table,if it is created only one table than DML can perform
on that table.
Operations are used in view:-Insert,Delete,Update.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to count groups returned with the group by clause in oracle?

580


What is oracle database client?

559


hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1567


What privilege is needed for a user to insert rows to tables in another schema?

565


What is archive log in Oracle?

605






What privilege is needed for a user to connect to oracle server?

561


How do I call oracle stored procedures that take no parameters?

570


What is oracle datasource?

557


How do you find out from the RMAN catalog if a particular archive log has been backed-up?

1661


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

1924


Why does Oracle not permit the use of PCTUSED with indexes?

1955


Why use resource manager in Oracle?

666


you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1564


How many categories of data types in oracle?

607


Explain the difference between replace() and translate() functions in oracle?

585