1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

Post New Answer

More DB Administration Interview Questions

what is the use of ocr?

0 Answers   Oracle,

WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,

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

4 Answers   DELL, TCS,

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

1 Answers  

What's the benefit of "dbms_stats" over "analyze"?

1 Answers  




How do you troubleshoot errors in a sql server agent job? : sql server DBA

0 Answers  

What types of replication are supported in sql server? : sql server DBA

0 Answers  

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

0 Answers  

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

0 Answers  

deleted of control file how will u recover control file?

4 Answers   CTS,

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers   HSBC,

What command would you use to encrypt a PL/SQL application?

1 Answers  

For more DB Administration Interview Questions Click Here
Categories