Tutorial#23 Learn How to combine two or more column/String using Concatenation Operator

Explaining How to combine two columns using the concatenation operator or in other words how to use concatenation in Oracle database or How to use concatenation operator for combining the output of two or more columns and how to use the literal character string orHow to join two column in SQL or Learn about the Concatenate function in the SQL Language.

In this series we cover the following topics:
SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator.

In this videos, you may get the answer the following question
concatenation operator in sql server
concatenate sql query
concatenate sql oracle
concatenate in oracle sql developer
oracle concatenate columns with space
concat in where clause oracle
concat string in where clause
insert concatenate string sql
sql string join
sql concatenate string
mysql concatenate string mysql query concatenate string

Follow me on:
Facebook Page:

Contacts Email:

Instagram:

Twitter:

[mr.schnitzel]

Your videos are way better than the videos in Udacity. I playlisted your 84 SQL videos. I appreciate the work that you put into these.

[mcsdigital]

Hey guys we have to use 'BETWEEN' keyword in the last assignment, i think sir forgot to tell us that, correct query is:
select first_name||last_name, hire_date from hr.employees where hire_date between '01-Jan-2003' and '01-Jan-2004';

[hustler]

U r awesome, thnx for these helpfull vedios.🙏🏻

[bloggerindex]

is this correct entry for question 3 ?


select 'my name is :-' || first_name,
'my salery is :-' || salary,
'my department is :-' || departmental_id,
from employee ;

[vikashmaurya]

question number 5 :-display first name and lastname (in single column ) from empl table who hired between 1-jan-03 to 01-jan-04;
what will be the query sir ?
select first_name || last_name from departments where hired between '01-01-2003' to '01-01-2004';
i tried though it is not correct

[amanahmed]

finally audio, video sync in this tutorial🤣🤣🤣

[mupparthiuma]

hi sir..select total_fee*2 || 'k' from student;'...is it correct statement to add K character to total_fee column.

[mohammedwaseem-dkbv]

Dear sir, i am struck in last assignment please help

[jayakrishnakittu]

To tough understand concatenation operator