what is the difference between simple view and complex view?
Answer Posted / paul james
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 ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the parameters that we can pass through a stored procedure?
How many file formats are supported to export data?
What are ddl statements in oracle?
How to install oracle database 10g xe?
What is an oracle database table?
What is oracle analytical function?
Is oracle a relational database?
What is the difference between post-database commit and post-form commit?
Explain the use of full option in exp command.
How to create a server parameter file?
What are advantages of dateset in datastage?
What are the uses of Database Trigger ?
Compare and contrast between sql and sql server and explain its various functions?
What is Segment Advisor in Oracle?
Where is the export dump file located?