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
Explain the use of consistent option in exp command.
Explain the use of grant option in exp command.
How to handle a single quote in oracle sql?
What are triggers in oracle?
List out the difference between commit, rollback, and savepoint?
Can select statements be used on views in oracle?
How do I start tns listener?
What is data block in Oracle?
6. Display the client name and order date for all orders using the traditional method.
How to load data through external tables?
What is the difference between Delete, Truncate and Drop in Oracle?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
What are the differences between char and nchar in oracle?
How to use subqueries with the in operator using oracle?
