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 / haarika valasa

IF view is created based on only one base table we can
perform all DML operations.

If view is created based on multiple table using joins and
goup by functions etc..than we cannot perform directly DML
operations.

Using Instead of Trigger we can perform DML operations on
complex view.

Is This Answer Correct ?    24 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it mandatory for the primary key to be given a value when a new record is inserted?

679


what are string data types? : Sql dba

484


Does oracle roll back the transaction on an error?

514


Does view store data in sql?

507


List out the acid properties and explain?

538






What is dml and ddl?

500


How to use distinct and count in sql query? Explain

584


Can ddl statements be used in pl/sql?

571


where are cookies actually stored on the hard disk? : Sql dba

553


What are types of joins?

516


What is the left table in sql?

491


The select into statement is most often used to create backup copies of tables or for archiving records?

540


How do I run a sql script?

491


What is a left join?

480


How do I write a sql query in pgadmin 4?

531