Is it possible to update the multiple field values in a single query? If possib

Is it possible to update the multiple field values in a
single query? If possible then write the actual query.

Question Posted / arup.imp

Is it possible to update the multiple field values in a single query? If possible then write the ac..

Answer / manjiri

update table_name
set col1=new_value, col2= new_value...
where condition/'s

Is This Answer Correct ?

14 Yes

1 No

More DB Administration Interview Questions

Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

what is the purpose of catlaog in oracle rman?

how can you create a user-defined lock?

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

what is logical system in sap basis

what do you understand by flashback feature of oracle?

what is ora 24313?what is the procedure to exclude that error?

what is grd?

what is a crs resource?

When a user process fails, what background process cleans up after it?

For more DB Administration Interview Questions Click Here