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 information schema in sql?

1054

What is keys and its types?

1060

What is a constraint? Tell me about its various levels.

1141

Does mysql support pl sql?

1144

Is join and inner join the same?

990

How to raise user-defined exception with custom sqlerrm ?

1116

Is not null in sql?

966

What are functions in sql?

936

I need a function for a train ticket reservation please answer it thanks in advance

1006

What are the three forms of normalization?

1033

Which join is like an inner join?

1012

Explain two easy sql optimizations.

995

Why schema is used in sql?

1029

What is difference between left and right outer join?

969

Is time a data type in sql?

888