what is the difference between simple view and complex view?
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
What is oracle rowcount?
What is the data pump export utility?
What is a proxy class?
What is raw datatype?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
How to connect to a remote server?
Explain the use of tables option in exp command.
When do you get a .pll extension in oracle?
Explain the importance of .pll extension in oracle?
How do I manually create a database in oracle?
Explain what are the type of synonyms?
How to assign values to data fields in record variables?
What is the difference between pre-select and pre-query?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
What is a directory object?