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
How to convert numbers to characters in oracle?
What is the minimum client footprint required to connect c# to an oracle database?
Explain how you would restore a database using RMAN to Point in Time?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
What is a Garbage Collection? and what is full recursive Garbage collection?
What is the difference between view and materialized view in Oracle?
Can we write insert statement in function in oracle?
How to define a cusotmer as a supplier in ORACLE R12
Explain what are the different type of segments?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is an index associated with a constraint?
How to invoke the original export import utilities?
What is meant by an index?
Why do you use stored procedures and state some of its disadvantages?