SQL tutorial: Update multiple Column into one column using the same table

The point of this tutorial is to show you how to update multiple column into one column using the same table.

Step 1
First you have to make sure that the select statement is correct, try to use the below example to see if your statement display the correct value.

Example:
select columnA||columnB from TABLE A;

if you wish to include some kind of delimiter
select columnA||', '||columnB from TABLE A;

Step 2
Update TABLE A set column A = (select columnA||', '||columnB from TABLE A where A.index = B.index);

Step 3
Once you are sure about your value, please commit the action.
commit();

That is it! This conclude the tutorial on how to update multiple column into one column using the same table!

Comments

My thought on USD/Gold fundamental analysis 09 April 2015

USD - ↔ Gold -↓ Current USA data is pointing to a robust recovery, with a stable employment rate and a stable growth. Yes the data from march was a major disappointment(weather?) but overall data so far is looking good, not great, but good. So what does good data means? USA is still out growing most developing countries and Euro even with just a "Good". Together with Oil price swinging ever lower, and with Iran joining in with the global oil market which will push oil price even lower. the inflation rate will set to be ever lower. Good Usa growth plus low inflation combine with non stop influx of credit, point to a market that investors dare to seek higher return with higher risk investment which is not good for Gold. So going long to mid term(end of 2015?), the Gold price would be projected to go down. I am aiming for at least a USD1100 per ounce range. Please be advise that forex is a high risk investment, there will be a very high chance of lost o...

Today's Forex Focus, 30 Jan 2024

Ah, nephew, let's dive into the Forex market today, shall we? It's like peering into a crystal ball, but with a bit more logic and a lot less mysticism. First up, we've got the EUR/USD pair showing a bit of a bearish tilt. The dollar's holding steady like a rock in a stream, buoyed by investors who've got their eyes glued to the upcoming Federal Reserve policy meeting. There's a bit of a buzz about geopolitical tensions in the Middle East, making investors a bit jittery and giving the dollar a bit of a boost. Then, there's talk about the Federal Reserve potentially pushing back against the idea of a rate cut anytime soon. This is like a plot twist in a thriller movie for the traders, who are now less convinced about a rate drop in March. The dollar, meanwhile, is flexing its muscles a bit, up by 0.19% against a basket of currencies. Across the pond, the Euro's taken a bit of a tumble, and there's chatter about when the European Central Bank might ...

My thought on USD fundamental analysis 07 April 2014

The US Non-Farm Payrolls was posted at 192,000 jobs gains in march. While this is a solid number and pointing to a healthy recover, the market was expecting a higher number at around 200,000. I would advise on holding on to USD as the country is recovering and will still show future growth. Russia is still an unknown variable as their attack on Ukraine seem to have slowed but had shown no sign of withdrawal from Crimea. North Korea with their latest nuclear testing seem to be testing the patient of the South Korea, USA and Japan. China had tighten their monetary policy while at the same time released mini-stimulus ... take extra care when dealing with China market. I would advise on not trading on precious market for this few weeks as the precious market is jumpy. PLEASE NOTE THAT FOREX TRADING WILL RESULT IN LOSING ALL YOUR MONIES.

Minor achievement

Search This Blog