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



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

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1 Answers  


What is checkpoint?

3 Answers   Accenture,


SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers   Cognizant,


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

1 Answers  


Explain about your sql server dba experience? : sql server DBA

0 Answers  






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

0 Answers  


What authentication modes does sql server support? : sql server DBA

0 Answers  


how can you record information about current session?

0 Answers   Oracle,


Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers   Infosys,


How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  


What is the difference between clustered and non-clustered index? : sql server DBA

0 Answers  


what functionality does oracle provide to secure sensitive information?

0 Answers   Oracle,


Categories