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

Explain constraining triggers.

593


Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1799


How to start your 10g xe server?

585


How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2387


Can a parameter be passed to a cursor?

596






What are the limitations of check constraint?

561


Whats the benefit of dbms_stats over analyze?

1489


Please explain oracle left join with an example?

581


What is translate in oracle?

615


What happens if you lost a data file?

576


Compare and contrast between sql and sql server and explain its various functions?

525


When do you get a .pll extension in oracle?

671


I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

1852


normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

1736


What are the most common interview questions on ETL Testing for experience?

587