a. Can you delete data from a View. b. If Yes, can you delete it if there are

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.

Question Posted / sql2000

1 Answers
7054 Views
CGI, I also Faced
E-Mail Answers

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. ..

Answer / 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