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
What the different topologies in which replication can be configured? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
how can you implement fine-grained auditing?
What are the different types of indexes available in sql server? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
how can you get actual data change values from previous transactions in oracle?
What are the different sql server versions you have worked on? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
how does an oracle clusterware manage crs resources?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What is dbcc? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Explain materialized views and how they are used.
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.