if i perform any operation on views such as insert, delete
etc will my base table get affected?????

Answer Posted / ramesh

yes if it is simple view. error if it is compunt view

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what is a view?

596


Explain the difference between rename and alias?

543


Is it possible to read/write files to-and-from PL/SQL?

650


If a cursor is open, how can we find in a pl/sql block?

673


What are the different types of sql commands?

599






Do foreign keys improve performance?

543


What are the most important characteristics of pl/sql?

573


Explian rowid, rownum?

560


How do you select unique values in sql?

498


How to fetch values from testtable1 that are not in testtable2 without using not keyword?

750


Are there any features that are decommissioned in 11g that are not present in 11g?

1591


Can a foreign key be null?

586


What does cursor do in sql?

515


What is update query?

547


What is compiled query?

516