what is the difference between table and veiw?
Answer Posted / udayah shankar dokku
Table: A table is defined as set of rows, a table
describes an entity.
View : view is a logical table ,which is defined as one or
more tables,a view is never stored in to database, when we
define view a view definition is stored in to dase
table,views are mainly used for security & information hiding
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
What is a private synonym?
How to shutdown your 10g xe server?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
How to estimate disk space needed for an export job?
What is hot backup and logical backup?
What is the difference between sharding and partitioning?
What is a user role in oracle?
How to use group functions in the select clause using oracle?
Difference between oracle's plus (+) notation and ansi join notation?
How to insert multiple rows with one insert statement in oracle?
How to rename a column in an existing table?
How would you best determine why your MVIEW couldnt FAST REFRESH?
Explain the use of grant option in imp command.
Is oracle the best database?