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

How to change sql*plus system settings?

1059

What is %rowtype in pl sql?

994

Why do we need unique key in a table?

959

what are date and time intervals? : Sql dba

1060

Is the primary key an index?

1026

What is the purpose of my sql?

953

What is prepared statement in sql?

1056

Why do we need view in sql?

990

What are the parts of a sql statement?

1090

How do you create a db file?

1020

How does rowid help in running a query faster?

1417

Why is partition used in sql?

1127

Can we join two tables without common column?

1010

explain about mysql and its features. : Sql dba

1018

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

1064