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

How to write numeric literals in oracle?

1157

What is system tablespace?

1074

List out the types of joins.

1135

What is a nvl function? How can it be used?

998

What is a view and how is it different from a table?

1026

how to clone 9i Database on to 10g Database.

2319

Is oracle a language?

925

What is the quickest way to export a table to a flat file?

949

How to turn on or off recycle bin for the instance?

1048

Why do you create or replace procedures rather that drop and recreate.

989

What is the difference between online and offline backups?

1033

How will you differentiate between varchar & varchar2?

1024

Explain alias?

1106

How to store only time; not date and time?

1005

How to execute the package in oracle?

1068