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

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

How would you begin to troubleshoot an ORA-3113 error?

i need a brief information about db2 dba course and realtime experts if any plz inform me nareshbhupathi93@gmail.com plzzz urgent

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

What are the operating modes in which database mirroring runs? : sql server DBA

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

What is replication? : sql server DBA

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

orra 1555 what is this error,why it is occur?

Explain the use of setting GLOBAL_NAMES equal to TRUE.

what is the last version,the release date of that version and fix pack of ibm db2 udb?

For more DB Administration Interview Questions Click Here