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 do we represent comments in oracle?

999

How to check your oracle database 10g xe installation?

924

How to create a stored program unit?

1115

How to call a stored function in oracle?

949

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

917

What is a system tablespace?

1003

Will you be able to store pictures in the database?explain.

928

How to set a transaction to be read only in oracle?

1030

What is oracle host variable?

980

Explain what are the type of synonyms?

1053

What do database buffers contain?

957

How to load data from external tables to regular tables?

985

How to use null as conditions in oracle?

1000

What is a server parameter file in oracle?

1000

In oracle there is column command, how will you explain that?

966