Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between simple view and complex view?
- 13 Answers
- 53190 Views
- I also Faced
- E-Mail Answers
Answer Posted / subbu
A Simple view selects from one table. A Complex view
selects from one or more tables.
A Simple view does not contain functions but Complex views
contain functions.
You can perform DML through Simple views but you cannot
always perform DML through Complex views.
| Is This Answer Correct ? | 38 Yes | 6 No |
Post New Answer View All Answers
How to save query output to a local file?
Describe varray?
How to create a table index in oracle?
What is the difference between I and G in Oracle?
Where are the settings stored for each instance in oracle?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
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 is Redo Log Buffer in Oracle?
How many data types are supported?
What is the difference between 10g OEM and 11g OEM?
Can you tell me how to add new column in existing views?how?How is possible?
How to convert characters to numbers in oracle?
What is a server parameter file in oracle?
What is the implicit cursor in oracle?
How to start instance with a minimal initialization parameter file?
