[WEBINAR] Bulletproof: How Today's Business Leaders Stay on Top


Definition - What does Concatenation mean?

Concatenation, in the context of databases, refers to the joining together two or more things into a large one. In database parlance, the things being joined are generally two table fields which may be from the same or different tables.

Techopedia explains Concatenation

The most common use of concatenation is to join two database fields that are stored separately but usually operated upon together. Take for example to fields named ‘FIRST NAME’ and ‘SURNAME’. These two fields are sometimes as two stored separate fields, but when retrieving them the viewer will usually want to see both names.

Concatenation is achieved by use of a special concatenation operator in a SQL query. For example, Oracle Database uses the || operator to join two strings. A sample SQL query to achieve this is:

SELECT first_name||’ ‘||surname FROM customer_master.

Note that in this case we have also included a space (enclosed by ‘ ‘) between the two names. This is simply to enhance the legibility of the final output. If we just joined the two fields without a space in between the query would be:

SELECT first_name||surname FROM customer_master.
This definition was written in the context of Databases
Share this:

Connect with us

Email Newsletter

Join thousands of others with our weekly newsletter

The 4th Era of IT Infrastructure: Superconverged Systems
The 4th Era of IT Infrastructure: Superconverged Systems:
Learn the benefits and limitations of the 3 generations of IT infrastructure – siloed, converged and hyperconverged – and discover how the 4th...
Approaches and Benefits of Network Virtualization
Approaches and Benefits of Network Virtualization:
Businesses today aspire to achieve a software-defined datacenter (SDDC) to enhance business agility and reduce operational complexity. However, the...
Free E-Book: Public Cloud Guide
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.