A View is said to be simple View when it is created using a single table.

what is the difference between simple view and complex view?

Question Posted / priya reddy

Answer Posted / priya reddy

A View is said to be simple View when it is created
using a single table.
A view is said to be comple view when it is created
on two or more tables

Is This Answer Correct ?

51 Yes

14 No

Please Help Members By Posting Answers For Below Questions

Where is the export dump file located?

1158

How to define a data source name (dsn) in odbc manager?

1034

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1078

How to assign data of the deleted row to variables?

1075

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2625

Give the different types of rollback segments.

1031

How to drop an existing view in oracle?

946

What is dynamic proxy?

1011

What are the differences between number and binary_float in oracle?

1104

Explain the use of log option in exp command.

1121

what are the advantages of running a database in archive log mode?

2205

Explain compound trigger in oracle?

1044

What is the difference between PFILE and SPFILE in Oracle?

1062

what is the difference between restoring and recovering?

1011

How to test null values?

1112