can we update a view which is created from two tables
- 11 Answers
- 34712 Views
- I also Faced
- E-Mail Answers
Answer Posted / usha
UPDATE PRODUCT SET UNITPRICE=UNITPRICE+(UNITPRICE*0.2)WHERE
CATEGORIES.CATEGORYNAME=PRODUCT.CATEGORYID;
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
what is dbms? : Sql dba
What is the best sql course?
how to escape special characters in sql statements? : Sql dba
Can we rollback truncate?
Is primary key clustered index?
what is sql server agent? : Sql dba
how to use regular expression in pattern match conditions? : Sql dba
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
Can delete statement be rollbacked?
what are all the common sql function? : Sql dba
Is primary key always clustered index?
What is your daily office routine?
Is inner join faster than left join?
Do we need to rebuild index after truncate?
what are aggregate and scalar functions? : Sql dba
