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...

Difference between views and materialized views?

Answer Posted / a.jyothsna

VIEWS: Takes the output of a query
M.VIEWS: Stores the output of a query,Views can't store
the results of a query

Is This Answer Correct ?    12 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference between sql and t-sql? : Transact sql

1043


What is error ora-01000: maximum open cursors exceeded

1071


how to decrement dates by 1 in mysql? : Sql dba

970


How many types of functions are there in sql?

899


Why do we use %rowtype & %type in plsql?

994


What is the maximum number of columns in sql table?

1090


what is timestamp in mysql? : Sql dba

1007


What is the purpose of the primary key?

1010


what is an index? : Sql dba

936


How to handle bulk data?

1269


in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2024


How much does sql certification cost?

1018


How do I add a database to sql?

1066


Which is faster view or stored procedure?

889


What are all types of user defined functions?

1007