Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

Question Posted / arup.imp


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

what is grd?

0 Answers   Oracle,

How to determine the service pack currently installed on SQL Server?

1 Answers  

how will you see when the database was started using sql prompt?

2 Answers   IBM,

Hot backup procedure?

2 Answers  

What purpose does the model database server? : sql server DBA

0 Answers  

Can you redefine a table online?

0 Answers   Oracle,

What is RAID and what are different types of RAID configurations?

1 Answers  

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

2 Answers   CTS,

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  

How can you control the amount of free space in your index pages? : sql server DBA

0 Answers  

When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers  

how does an oracle clusterware manage crs resources?

0 Answers   Oracle,

For more DB Administration Interview Questions Click Here
Categories