update <table_name> set (<colname> <condition>)[where&

wirte the syntax of update query?

Question Posted / nageswararao.k

Answer Posted / nageswararao.k

update <table_name> set
(<colname> <condition>)[where<condition>];

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2288

Write a trigger example in oracle?

1045

What are the set operators union, union all, minus & intersect meant to do?

983

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1078

Is oracle the best database?

959

Explain the difference between a procedure and a function? What do you understand by those terms?

1069

What is a static data dictionary in oracle?

1099

Query to retrieve record for a many to many relationship ?

2507

What is connection pool in oracle?

981

Differentiate between post-database commit and post-form commit?

1025

What are the different editions of oracle?

1101

What is execute immediate in oracle?

1011

What is a tns service name?

1000

What are the differences between blob and clob in oracle?

1078

can u plz provide me oca sql dumps please i need them

1941