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 can you view the errors encountered in a trigger?

960

What are properties of the transaction?

998

Explain the significance of the & and && operators in pl sql.

1007

Is sql developer case sensitive?

994

What is execution plan in sql?

1041

Can we create clustered index without primary key?

962

How many postgresql users are there, worldwide?

1057

Can a trigger call a stored procedure?

1068

what is text? : Sql dba

1065

What are dml commands?

1020

What does partition by mean in sql?

959

What is pivot in sql?

909

What is the difference between microsoft sql and mysql?

959

What is the starting oracle error number?

1051

What is the most restrictive isolation level? : Transact sql

1083