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 use regular expression in pattern match conditions in oracle?
Differentiate between pre-select and pre-query?
How to synchronize 2 schema's objects?
In which language oracle has been developed?
In oracle there is column command, how will you explain that?
What is different types of joins?
What is oracle rowcount?
What are the various oracle database objects?
Explain what are synonyms used for?
Explain an index?
How to invoke the data pump import utility?
What is null value in oracle?
Give the constructs of a package, function or a procedure.
What is Reduced List of Values?
How can you merge two tables in oracle?