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
What is the purpose of tables, private synonyms and public synonyms in Oracle?
How to do clean up if create database failed?
What is ADDM Advisor in Oracle?
How to put more than 1000 values into an oracle in clause?
What happens to the data files if a tablespace is dropped?
What happens to the current transaction if a ddl statement is executed?
Explain an exception?
What is java oracle used for?
Explain the function of optimizer in oracle?
How to create id with auto_increment on oracle?
Is rowid unique in oracle?
How many types of synonyms in Oracle?
How to best split csv strings in oracle 9i?
Will you be able to store pictures in the database?
What is Virtual Private Database in Oracle?
