can we update a view which is created from two tables
Answers were Sorted based on User's Feedback
Answer / guest
Yes , we can update a view which is based on more than one
table. And data will get updated in base tables also.
| Is This Answer Correct ? | 21 Yes | 28 No |
How to select random rows from a table?
What does an inner join do?
Can 2 queries be executed simultaneously in a distributed database system?
How do I run a script in sql developer?
What can I use instead of union in sql?
What is fmtonly in sql?
How do temporal tables work?
What is count * in sql?
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
What are the different types of joins and explain them briefly.
What is the use of a view in sql?
Why do we use subquery?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)