adspace


If we update a complex view, is base table will get update ?

Answer Posted / dinesh

Yes We can update base table through complex view
Using "Instead of trigger"

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is primary key clustered index?

1025


Does group by remove duplicates?

1118


Is inner join faster than left join?

1286


What is the current version of sql?

1103


Can delete statement be rollbacked?

1064


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

2099


Can we use distinct and group by together?

1145


what is schema? : Sql dba

1160


what is bcp? When does it used? : Sql dba

1065


How do I remove duplicates in two columns?

1201


What is the best sql course?

1061


Is primary key always clustered index?

1101


how to use regular expression in pattern match conditions? : Sql dba

1122


What is the current version of postgresql?

1187


define sql insert statement ? : Sql dba

1107