Answer Posted / kumar
No, view do mot contain data. it contains only the SQL
Statement.
When we try to fetch the data from view , it internally
hits the table and get the data from the table.
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
How to retrieve data from an cursor to a record?
What are a query and state the different types of queries and their uses?
What is format trigger?
What is sequence?
What is the difference between postgresql and 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?
What is an oracle database?
What is a dead lock in oracle?
Can you drop an index associated with a unique or primary key constraint?
Explain the use of record length option in exp command.
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.
What happens if variable names collide with table/column names?
What is transaction control statement and how many types of transaction control statement in Oracle?
What is an oracle?
How to divide query output into groups in oracle?