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 / barun
A.Yes we can delete data from view.actually we deleting
data from crrospondind tabls or tables data by which view
is created.
b.if view is create by multi table then some condition
oracle follow-
1.if view contain group by,distinct then we cant delete
data.
2.if table contain colume data function or calculation we
can't.
3.if table contain not null value we can't delete.
Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
Show the two pl/sql cursor exceptions.
What is the difference between cross join and natural join?
How many row comparison operators are used while working with a subquery?
what are all different types of collation sensitivity? : Sql dba
Explain raise_application_error.
What is meant by temporal data?
what is an index? : Sql dba
what is the difference between char_length and length? : Sql dba
how are mysql timestamps seen to a user? : Sql dba
Write the alter statement to enable all the triggers on the t.students table.
what is self-join? : Sql dba
What is update query?
What is an ndf file?
Is oracle sql free?
What is difference between function and trigger?