a. Can you delete data from a View.
b. If Yes, can you delete it if there are multiple tables
c. If No, can you delete if there is single source table
which is joining.
Answer Posted / pankaj
you can remove the rows from the view if it does not containing any of the following.
1> group function
2> group by clause
3> distinct keyword
4> rownum keyword
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can we insert delete data in view?
How does sql developer connect to oracle database?
How would you reference column values before and after you have inserted and deleted triggers?
Explain the uses of control file.
How do I make sql search faster?
What is difference between cursor and trigger?
Are pl sql variables case sensitive?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
What does trigger mean in slang?
what is not null constraint? : Sql dba
What are the different datatypes available in PL/SQL?
What is the difference between sql and mysql?
Is pl sql different from sql?
What are the advantages of pl sql over sql?
How many joins in sql?