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 count 1 and count (*) in a sql query?
How to test for null values?
What are the types of dbms?
What found sql?
What sql does db2 use?
What are the different ddl commands in sql?
what is an index? : Sql dba
What is sqlite used for?
can sql servers linked to other servers like oracle? : Sql dba
How is a process of pl/sql compiled?
Why is sharding used?
What is sql and also describe types of sql statements?
How can we debug in PL/SQL?
What does seeding a database mean?
Explain the advantages and disadvantages of stored procedure?