UPDATE PRODUCT SET UNITPRICE=UNITPRICE+(UNITPRICE*0.2)WHERE CATEGORIES.CAT

can we update a view which is created from two tables

Question Posted / usha

Answer Posted / usha

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

Is This Answer Correct ?

7 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the use of <> sql?

1036

Define tables and fields in a database

1173

how to get a list of columns in an existing table? : Sql dba

1001

How to know the last executed procedure?

1152

What is the difference between function and procedure in pl/sql?

1134

How do you break a loop in pl sql?

1097

What does fetching a cursor do?

1130

What is clause?

1222

How do you use join?

989

What are the different operators available in sql?

1054

What is the process of copying data from table a to table b?

1132

What is join view in sql?

986

What is range partitioning?

1011

how to get @@error and @@rowcount at the same time? : Sql dba

1073

Write a sql select query that only returns each name only once from a table?

1071