Oracle Database11g tutorials 6 | | How to use Concatenation operator, character String

hey guys this is Manish and today in this orle database video we will see how to use concatenation operator for combining the output of two or more column and how to use literal character string first of all open up your SQL Developer tool or you can use terminal command prom whatever you like in our previous SQL tutorial we saw how to retrieve data using SQL select a statement something like first name last name from employees as you can see the result of this cury we got two independent column values isn't it cool if we can change this output in more user friendly and meaningful string don't worry in this SQL tutorial we will see how to do this now we are going to combine the value of column first name and last name using concatenation Operator concatenation Operator is the binary operator provided by Oracle acts on two operants these operants can be column or a literal character string first we will see how to use concat initi operator for combining column values let's see how first of all write a select statement like select our first column name then concatination operator followed by our second column name which is last name from employees which is our table name then Terminator execute this cury here is our result as you can see it's a single column with a clumsy heading don't worry I'll show you how to fix it but before that there is a problem with this result as you can see there is no space between first and last name which makes it clumsy too let's fix it first to make it more friendly just add a space between column name s come here just after concatenation operator add a single code and then space and again a single code followed by another concatenation operator that's it execute this cury here we go now it's fine that's how we use concatenation operator to combine column values let's see how to use literal string say you want to print the employee ID of Mr Douglas Grant is 199 here we are using two string first one is the employee ID of Mis and the second one is is Douglas Grant and 199 are the value from column first name last name and employee ID of database let's see how to do this write a select a statement as select single quote and a first string which is the employee ID of Mis close the single code and now put concatenation operator then a First Column name which is first name again concatenation operator and single code hit a space close the single code and put another concatenation operator and our second column name which is last name followed by one another concatenation operator and our second string single code is close the single code followed by Third column name but before that another concatenation operator and the third column name which is employee ID from employees which is our table and then Terminator execute this cury that's our answer okay just put a space here that's perfect here is our answer the employee ID of Mr Douglas Grant is 199 again as you can see the heading of this column is not [Music] what we want let's fix this heading to fix the heading of this column you can give the alas to this column for doing that come here at the end of a string write s start the double code give whatever heading you want like I want to give detail close the double coat and execute the cury perfect test up answer s okay that's it for today you can download this script also link for which is provided in the description below I'm sharing it using copy Cloud you can also join the copy cloud and get 15gb of free storage and if you use my referral link we both will get extra 5gb which means free 20 GB of cloud storage check video description for my referral link that's it for today if you enjoy please like share comment and subscribe thanks for watching this is Manish