Basic Oracle Concepts and Programming Question:
Download Job Interview Questions and Answers PDF
How To Concatenate Two Text Values in Oracle?
Answer:
There are two ways to concatenate two text values together:
* CONCAT() function.
* '||' operation.
Here is some examples on how to use them:
SELECT 'ggl' || 'Center' || '.com' FROM DUAL;
globalguideline.com
SELECT CONCAT('globalguideline','.com') FROM DUAL;
globalguideline.com
* CONCAT() function.
* '||' operation.
Here is some examples on how to use them:
SELECT 'ggl' || 'Center' || '.com' FROM DUAL;
globalguideline.com
SELECT CONCAT('globalguideline','.com') FROM DUAL;
globalguideline.com
Download Oracle Database Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How To Use NULL as Conditions in Oracle? | How To Increment Dates by 1 in Oracle? |