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 are the set operators union, union all, minus & intersect meant to do?
does the query needs a hint to access a materialized view?
How to define a data field as not null?
What is key preserved table?
What is the oracle implicit cursor?
Explain about achiever in sql?
What is the difference between PFILE and SPFILE in Oracle?
How can I create database in oracle?
How to drop an index in oracle?
What is meant by raw datatype?
How to connect ms access to oracle servers?
Which is better Oracle or MS SQL? Why?
Explain the use of log option in exp command.
How to get a create statement for an existing table?
How many categories of data types?
