Interested to Buy Any Domain ? << Click Here >> for more details...
Is it possible to update the multiple field values in a
single query? If possible then write the actual query.
- 1 Answers
- 4369 Views
- Oracle, I also Faced
- E-Mail Answers
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 do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
what is the use of recording information about current session?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is a correlated sub-query? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
how can you find out if a table can be redefined?
What is dbcc? : sql server DBA
how does an oracle clusterware manage crs resources?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What is the difference between dropping a database and taking a database offline? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
How do you open a cluster administrator? : sql server DBA
