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 retrieve values from data fields in record variables?
What is raw datatype in oracle?
How to connect asp pages to oracle servers?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
How to define a data field as not null?
What is a trace file and how is it created in oracle?
Explain the use of show option in imp command.
Difference between open_form and call_form in oracle.
Explain the different normalization forms?
What are the different types of synonyms?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
What is instant client 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.
Can we create trigger on materialized view in oracle?
What is oracle latest version?