can we update a view which is created from two tables

Answer Posted / usha

UPDATE PRODUCT SET UNITPRICE=UNITPRICE+(UNITPRICE*0.2)WHERE
CATEGORIES.CATEGORYNAME=PRODUCT.CATEGORYID;

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between count 1 and count (*) in a sql query?

667


How to test for null values?

767


What are the types of dbms?

718


What found sql?

700


What sql does db2 use?

726






What are the different ddl commands in sql?

739


what is an index? : Sql dba

720


What is sqlite used for?

699


can sql servers linked to other servers like oracle? : Sql dba

749


How is a process of pl/sql compiled?

775


Why is sharding used?

726


What is sql and also describe types of sql statements?

754


How can we debug in PL/SQL?

853


What does seeding a database mean?

689


Explain the advantages and disadvantages of stored procedure?

853