If a View on a single base table is manipulated will the
changes be reflected on the base table?
Answers were Sorted based on User's Feedback
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 |
Answer / aks
Depends on privileges granted to view (select,insert,update);
Is This Answer Correct ? | 4 Yes | 1 No |
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 |
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 |
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
what are the performance and scalability characteristics of mysql? : Sql dba
HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP
What is sharding in sql?
What is an inconsistent dependency?
What is sql and explain its components?
Can a primary key be a foreign key?
what is the difference between delete and truncate statement in sql? : Sql dba
What is a stored procedure in sql with example?
select 1,col1,col2 from table1. output?
Is sql a dbms?
1> how are u debugging in plsql ? 2> how to connect oracle database from unix. is there ne way other than using sqlplus ?