Bookmark

Forum | Directory | Blog |

GlobalGuideLine.Com

HTML Tutorial

JavaScript Tutorial

SQL Tutorial

CSS Tutorial

XML Tutorial

XSLT Tutorial

Articles

Interview Questions & Answers

Jobs

Our Services

Statistics of Global GuideLine

    
     Home

Basic SQL Guide.
SQL Introduction.
What is Table?
SQL Create Table.
SQL Insert Statement.
SQL Select Keyword.
SQL Order by clause.
SQL Count Statement.
SQL Group By Clause.
SQL Having Clause.
SQL Alias Tables.
SQL Join Tables.
SQL Outer Join.
SQL Update Statement.
SQL Delete Statement.
SQL Distinct Keyword.
SQL Where Keyword.
SQL And Or Keyword.
SQL In Keyword.
SQL Between Keyword.
SQL Like Keyword.
SQL Functions.
SQL Concatenate.
SQL Substrings.
SQL Trim Function.
SQL Constraints.
SQL Primary Key.
SQL Foreign Key.
SQL Cerate Views.
SQL Create Index.
SQL Alter Table.
SQL Drop Table.
SQL Truncate Table.
SQL Summary.

SQL Concatenate.

Back Next

SQL Tutorial will explain us that sometimes it is necessary to combine together (concatenate) the results from several different fields from one or more database tables. Each database provides a way to do this but each database follows the different way from others.

Syntax for SQL Concatenate

►MySQL:      CONCAT() 

►Oracle:     CONCAT(), ||

►SQL Server: +

The syntax for CONCAT() Function is as follows:

CONCAT(str1, str2, str3, ...): Concatenate str1, str2, str3, and any other strings together. Please note the Oracle database CONCAT() function only allows two arguments -- only two strings can be put together at a time using this function. However, it is possible to concatenate more than two strings at a time in database Oracle using '||' sign.

Let's look at some SQL Concatenate examples. Assume we have the following table:

Table: Employees

FirstName	LastName	Email	DOB	Phone
Austin	Hennery	austin.it@gamail.com	24/11/1978	446 102-2222
Creston	Narvon	narvon_crest@hotmail.com	22/04/1976	443 325-4545
Kate	Bladen	kbladen@usa.net	01/05/1980	326 503-3232
Angela	Julie	julieee@yahoo.co.uk	11/12/1977	326 323-8888
Bobbi	Ferguson	bobi123@kiwibox.com	10/02/1970	506 252-9875
Cute	Alfa	cafa@gmail.com	19/05/1972	506 272-4566

SQL Concatenate Examples in Oracle, MySQL and SQL Server

Example 1:

In MySQL/Oracle Concatenate Example.

SELECT CONCAT(FirstName,LastName) "Employee First & Last Name" FROM Employees
ORDER BY FirstName ASC

Results of Concatenate Example using Oracle or MySQL databases.

Employee First & Last Name

AustinHennery

AngelaJulie

BobbiFerguson

CrestonNarvon

CuteAlfa

KateBladen

Example 2:

Oracle Concatenate more then two columns Example.

SELECT FirstName || ' ' || LastName || ', contact number is ' || Phone FROM Employees
ORDER BY FirstName ASC;

Results of SQL Concatenate more then two columns Example in Oracle

Employee First & Last Name with Phone Number

Austin Hennery, contact number is 446 102-2222

Angela Julie, contact number is 326 323-8888

Bobbi Ferguson, contact number is 506 252-9875

Creston Narvon, contact number is 443 325-4545

Cute Alfa, contact number is 506 272-4566

Kate Bladen, contact number is 326 503-3232

Example 3:

SQL Concatenate Example in SQL Server.

SELECT FirstName + ' ' + LastName FROM Employees
ORDER BY FirstName ASC;

Results of SQL Concatenate Example in SQL Server.

Employee First & Last Name

Austin Hennery

Angela Julie

Bobbi Ferguson

Creston Narvon

Cute Alfa

Kate Bladen

Back Next

HTML Rendering of above code:

[ About ] [ Contact ] [ Home ]
[ Links ] [ Site Map ] [ Services ] [ Privacy ]


	Copyright © 2005 - 2013 www.globalguideline.com All rights reserved. (Best viewed in IE 6.0+ or Firefox 2.0+ at 1024 * 768 or higher) 700 visitors are online now Please Like our Facebook Page! Please give us a +1 !