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 is a sub query and what are the different types of subqueries?
How will you write a query to get a 5th rank student from a table student_report?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
What is analyze command used for?
How to pass parameters to procedures?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
What is oracle used for?
What is oracle datasource?
What are ddl statements in oracle?
why dont we assign not null constraint as table level constraint.
What is columnar storage what is the advantage?
How do I spool to a csv formatted file using sqlplus?
How to change program global area (pga) in oracle?
How do we create privileges in oracle?
How to set up autotrace for a user account?