Posts

Showing posts from October, 2005

My saturday :)

There's something satisfying abt saturdays.I really love the peacefulness and quietness. The world needs more peace like this. Until an idiot[my roommate] switched on the television for which he kept the volume too high (in such an way that ppl in the next flat can hear the programme) ! Idiot [ does not knew abt taste of early morning sleep ] . I woke up today [ saturday ] and wondered what should I do. *Sigh* My Saturdays are very routine. Wake up, eat, play some games, watch TV and then do the usual house chores. Yes, I'm domestically trained! :) I decided to watch a movie instead and ended up watching a program in Jaya TV ;). After that, it was back to washing clothes & cleaning. Then blogged something in PUZZLE Hahah...hmmmm..that's about it for my "eventful" Sunday

What is a view?

A view is a tailored presentation of the data contained in one or more tables (or other views). Unlike a table, a view is not allocated any storage space, nor does a view actually contain data; rather, a view is defined by a query that extracts or derives data from the tables the view references. These tables are called base tables. Views present a different representation of the data that resides within the base tables. Views are very powerful because they allow you to tailor the presentation of data to different types of users. Views are often used to: => provide an additional level of table security by restricting access to a predetermined set of rows and/or columns of a table => present the data in a different perspective from that of the base table => simplify commands for the user => isolate applications from changes in definitions of base tables => hide data complexity => express a query that cannot be expressed without using a view