Interested to Buy Any Domain ? << Click Here >> for more details...
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 Reduced List of Values?
What is a directory object?
How to get execution statistics reports on query statements?
How to create lov dynamically at runtime & attach to text field?
How to assign query results to variables?
Explain the use of indexes option in imp command.
How to do a full database export?
What is a lookup table in oracle?
What is a proxy class?
How to select all columns of all rows from a table in oracle?
What are the uses of Database Trigger ?
What is dual table oracle?
What is oracle data type?
What is a synonym? What are its various types?
What is oracle update statement with inner join ?
