adspace


Can we insert delete data in view?

Answer Posted / Sonoo Kumar Kasaudhan

No, you cannot perform DML (Data Manipulation Language) operations such as INSERT, UPDATE, or DELETE on a View. These operations can only be performed on base tables.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is sql server agent? : Sql dba

1188


how to escape special characters in sql statements? : Sql dba

1124


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

1252


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2100


Is primary key clustered index?

1027


what are all the common sql function? : Sql dba

1141


Is primary key always clustered index?

1101


what is schema? : Sql dba

1163


what are the advantages of sql ? : Sql dba

1154


What is the current version of postgresql?

1188


Can we use distinct and group by together?

1146


Is inner join faster than left join?

1287


what are aggregate and scalar functions? : Sql dba

1142


What is the current version of sql?

1106


Can we rollback truncate?

1083