can we update a view which is created from two tables

Answer Posted / raj

folks, I check in practically that View (consist of more
then one table) can update and it impact at Base Table also.
(you can also check from your own self...)
but I data cannot delete from view.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do we need a foreign key?

538


How can we optimize a sql query?

567


How can I delete duplicate rows?

553


when MSQL8.0 is in market

1588


What is plpgsql language?

521






Can we use the cursor's to create the collection in PL/SQL?

509


what are the different index configurations a table can have? : Sql dba

562


What is crud sql?

534


how to rename an existing column in a table? : Sql dba

502


what is try_catch block in procedure

1185


Which command is used to delete a trigger?

760


What is field delimiter?

625


What is sql character function?

535


What is user in sql?

567


What is an emotional trigger?

508