Is it possible to update the multiple field values in a
single query? If possible then write the actual query.
Answer Posted / 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 View All Answers
How can you control the amount of free space in your index pages? : sql server DBA
What purpose does the model database server? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
how can you schedule a job in database?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
what is the last version,the release date of that version and fix pack of ibm db2 udb?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
what is the use of recording information about current session?
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?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What the different topologies in which replication can be configured? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.