Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

what is the difference between simple view and complex view?

Question Posted / ramu c

Answer Posted / ramu c

A View is said to be simple view it should have a single
select statement only.Where as a complex view migh contain
select statement with joins, sub queries etc...

Is This Answer Correct ?    78 Yes 13 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to export your own schema?

1007

What is ordinary table in oracle?

1157

1) Does oracle have any table which contain all the exceptions and it's code internally?

1749

What privilege is needed for a user to create views in oracle?

1046

Why use resource manager in Oracle?

1105

WHAT IS ecc 6.0

2147

How to use subqueries with the in operator using oracle?

1091

What are the differences between char and varchar2 in oracle?

1170

What is a trigger and what are its types?

1227

What are set operators?

1082

How to specify default values in insert statement using oracle?

1104

What is the difference between view and materialized view in Oracle?

1154

How to fetch the row which has the max value for a column?

1000

How to use an explicit cursor without open statements?

1055

How do you tell what your machine name is and what is its IP address?

2096