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

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

If CPU is very slow What can u do to speed up?

Give the reasoning behind using an index.

how can you implement fine-grained auditing?

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

what is grd?

Hot backup procedure?

What is blocking and how would you troubleshoot it?

what is meant by gateway

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

Where in the Oracle directory tree structure are audit traces placed?

what r the types of backup?

For more DB Administration Interview Questions Click Here