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

what is a view?

Answer Posted / roopesh kumar

A view is a logical db object which is created for data
security, data hiding etc. In database onle views
defination stored.

Syntax: create or replace view name_vw as select col1,
col2, ......... from table1, table2 where ....;

Types: (1) simple view
(2) complex view
(3) read only view
(4) force view
(5) with check option

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to delete a column in an existing table in oracle?

1011


What is define in oracle?

1000


Explain integrity constraints?

1060


Explain the use of indexes option in exp command.

1066


What is an oracle recycle bin?

932


How to use "in" parameter properly?

1006


How to create additional tablespaces for an new database?

970


How to use an explicit cursor without open statements?

1014


What is object data modeling?

907


What is bulk load in oracle?

1008


What is a trigger and what are its types in oracle?

1001


What is an Oracle Instance?

1073


How to get the Installed Oracle Version Information ?

1075


What are the database administrators utilities available?

973


What is rich query?

929