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
How to delete a column in an existing table in oracle?
What is define in oracle?
Explain integrity constraints?
Explain the use of indexes option in exp command.
What is an oracle recycle bin?
How to use "in" parameter properly?
How to create additional tablespaces for an new database?
How to use an explicit cursor without open statements?
What is object data modeling?
What is bulk load in oracle?
What is a trigger and what are its types in oracle?
What is an Oracle Instance?
How to get the Installed Oracle Version Information ?
What are the database administrators utilities available?
What is rich query?