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 / niranjan dhungia

Answer Posted / niranjan dhungia

simple view refer the data from only single table. Complex
view refer data from more than one table. For simple view
we can use group function(avg,sum etc) but in complex view
we can use group function.

Is This Answer Correct ?    13 Yes 43 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain parameter file in oracle.

1030

How to download oracle database 10g xe?

1018

How will you identify oracle database software release?

1010

Explain the use of record option in exp command.

1006

How can you merge two tables in oracle?

1001

What is SQL Tuning Advisor in Oracle?

1181

How do I call oracle stored procedures that take no parameters?

1116

What is user managed backup in Oracle?

1146

What is a Garbage Collection? and what is full recursive Garbage collection?

2905

What is difference between truncate and delete?

1040

What are the differences between blob and clob in oracle?

1089

How to run create database statement again?

1157

Can sub procedure/function be called recursively?

1004

What are the different oracle database objects?

1092

Difference between varchar and varchar2 data types?

1185