Answer Posted / ashis
View is a virtual table or logical table or it can be
represented as mirror if table.View allows performing
transaction on table virtually.Table may contain "n" number
of views.View can be based on single table or more than one
table with help of join.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Which dictionary tables and/or views would you look at to diagnose a locking issue?
Will you be able to store pictures in the database?explain.
How to upsert (update or insert into a table)?
What are the different types of record groups in oracle? Explain each of them
How to run create database statement again?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
What is the oracle implicit cursor?
what are steps for interface? where is exchange rate defined in which table?
Can we commit inside a function in oracle?
How to define a data source name (dsn) in odbc manager?
What are the ansi data types supported in oracle?
What is the string concatenation operator in oracle?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
How to create a stored function in oracle?
