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

Can we use the cursor's to create the collection in PL/SQL?

972

What is a recursive stored procedure?

1118

What is difference between left and right outer join?

949

What is difference between stored function and application function?

1127

What are all the ddl commands?

1134

Can we perform dml in function?

1028

How exception handling is done in advance pl/sql?

942

What is time based sql injection?

918

What is date functions?

975

How do I upgrade sql?

962

What is sql integrity?

1079

How do I run pl sql in sql developer?

1078

Explain the uses of a database trigger?

1002

What is sequence in sql?

961

How to write pl sql program in mysql command prompt?

1034