Answer Posted / manoj
This is a virtual table do not have physical existence
only at run time it retrive valves from one or more than
one tables.
opertion: insert , update , delete
case 1:- If view created on only one table than DML
can perform on that TABLE
case 2:- If view Made on more than one then DML cant
possiple
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is oracle rownum?
How to convert character types to numeric types?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What is user managed backup in Oracle?
various types of hints and their usage
What are the different types of modules in oracle forms?
Is there any function in oracle similar like group_concat of mysql?
How to define an anonymous procedure without variables?
What is a Garbage Collection? and what is full recursive Garbage collection?
What are the advantages of oracle 12c?
What is a system tablespace?
How to view all columns in an existing table?
What are the arithmetic operations?
When do we use group by clause in a sql query?
Explain what are the uses of rollback segment?
