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 |
What is the usage of sql functions?
What are the datatypes available in pl/sql ?
how many tables will create when we create table, what are they? : Sql dba
What is the maximum number of triggers,can apply to a single table?
how to drop an existing index in mysql? : Sql dba
how to create table with in the procedure or function?
What is tuple in sql?
What is the difference between local and global temporary table?
what is External tables? explain with examples
why use cursors?
1.when will you use week refcursor and when will you use strong ref cursor ? 2.what is the use of sql trace..how do you use it ? 3.can you please send all the sql plus commands...like set line 6000....
how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently
Oracle (3253)
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)