what is the difference between simple view and complex view?

Answer Posted / ali

simple view contains created with only one table whereas
cmplex view is created with more than one table

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create a table interactively?

556


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

543


What is system tablespace?

629


How can I see all tables in oracle?

538


Is truncate autocommit in oracle?

633






How can we force the database to use the user specified rollback segment?

554


What are the differences between interval year to month and interval day to second?

550


What is a tns file?

500


What is the purpose of tables, private synonyms and public synonyms in Oracle?

587


How to divide query output into groups in oracle?

555


Why use resource manager in Oracle?

661


What is oracle open database communication (odbc)?

555


WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

1800


What is the simplest tool to run commands on oracle servers?

511


Is oracle an open source?

632