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 / v v

Answer Posted / v v

A Simple view selects from one table. A Complex view
selects from one or more tables.
Both can use group functions..
Simple view can perform DML..
But complex views can't perform DML on parent table: can
perform only in child table

Is This Answer Correct ?    7 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many data types are supported?

1027

How can I combine multiple rows into a comma-delimited list in oracle?

1001

How to get last row id?

941

how do u setup a replication site?

1925

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

1015

How to assign query results to variables?

1013

How to convert character types to numeric types?

1056

How to export several tables together?

990

How to rename a column in an existing table?

973

Explain the use of owner option in exp command.

994

How do I recompile a procedure in oracle?

912

How can I get column names from a table in oracle?

985

What is a select query statement in oracle?

901

Is java required for oracle client?

928

What is clustered table in Oracle?

1108