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
Is it mandatory for the primary key to be given a value when a new record is inserted?
what are string data types? : Sql dba
Does oracle roll back the transaction on an error?
Does view store data in sql?
List out the acid properties and explain?
What is dml and ddl?
How to use distinct and count in sql query? Explain
Can ddl statements be used in pl/sql?
where are cookies actually stored on the hard disk? : Sql dba
What are types of joins?
What is the left table in sql?
The select into statement is most often used to create backup copies of tables or for archiving records?
How do I run a sql script?
What is a left join?
How do I write a sql query in pgadmin 4?