If a View on a single base table is manipulated will the changes be reflected

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

If a View on a single base table is manipulated will the
changes be reflected on the base table?

Question Posted / guest

5 Answers
14633 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

If a View on a single base table is manipulated will the changes be reflected on the base table?..

Answer / ehsraka

Yes, definitely. Since the view is based on a single table
and falls within the cateogory of simple view. Any change /
modification on the records will be reflected in the base
table.

Is This Answer Correct ?

8 Yes

0 No

If a View on a single base table is manipulated will the changes be reflected on the base table?..

Answer / tulsi

yes it will be reflected in the base table

Is This Answer Correct ?

7 Yes

3 No

If a View on a single base table is manipulated will the changes be reflected on the base table?..

Answer / aks

Depends on privileges granted to view (select,insert,update);

Is This Answer Correct ?

4 Yes

1 No

If a View on a single base table is manipulated will the changes be reflected on the base table?..

Answer / naresh

Hi

Not only on a single based table, changes made on a view
which created on multiple tables also will update on base
tables,if the relation ship between primary key and Foreign
key relationships are proper and if the Integrity
constraints are mentioned.

Cheers!
Naresh

Is This Answer Correct ?

4 Yes

1 No

If a View on a single base table is manipulated will the changes be reflected on the base table?..

Answer / papal

yes if there is no use of "CHECK WITH option"
then definitally chnages in view affects the base table

Is This Answer Correct ?

3 Yes

1 No

Post New Answer