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
What do you mean by a database transaction & what all tcl statements are available in oracle?
How can we force the database to use the user specified rollback segment?
How to store only time; not date and time?
What privilege is needed for a user to connect to oracle server?
How to apply filtering criteria at group level in oracle?
What is data type in oracle?
How to write an inner join with the where clause in oracle?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
Explain what does a control file contain?
Point the difference between translate and replace?
How to shutdown your 10g xe server?
How do I spool in oracle?
How to define a data source name (dsn) in odbc manager?
What is hash cluster in oracle?
How to load data from external tables to regular tables?