can we update a view which is created from two tables
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 the difference between inner join and left join?
what is table? : Sql dba
Can we use joins in subquery?
What are the different dcl commands in sql?
How to find 3rd highest salary of an employee from the employee table in sql?
Show how functions and procedures are called in a pl/sql block.
Can function return multiple values in sql?
What is range partitioning?
How would you reference column values before and after you have inserted and deleted triggers?
Why is pl sql needed?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
What is error ora-01000: maximum open cursors exceeded
can sql servers linked to other servers like oracle? : Sql dba
what are the advantages of using stored procedures? : Sql dba
What is acid property in a database?