what is view?

Answer Posted / manoj

This is a virtual table do not have physical existence
only at run time it retrive valves from one or more than
one tables.

opertion: insert , update , delete

case 1:- If view created on only one table than DML
can perform on that TABLE

case 2:- If view Made on more than one then DML cant
possiple

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

 What are the oracle DML commands possible through an update strategy?

579


State and explain the different types of data models?

527


What is an oracle database table?

588


Why should I use oracle database?

567


How to create an initialization parameter file?

535






What are a query and state the different types of queries and their uses?

508


What is the maximum number of triggers that can be applied to a single table?

551


How to execute the package in oracle?

565


From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

581


What is the purpose of save points in oracle database?

538


What are the ways tablespaces can be managed and how do they differ?

1612


What are the restrictions in a oracle read only transaction?

562


How to delete a column in an existing table in oracle?

598


Can the query output be sorted by multiple columns in oracle?

565


How a database is related to tablespaces?

576