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
- 4431 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
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What are the different types of upgrades that can be performed in sql 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..?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
what are the benefits of flashback feature?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
what do you understand by fine-grained auditing?
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.
What the different components in replication and what is their use? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
