Is obiee and SQL are related

The PL / SQL Concat function combines two strings into one common string. The Function Concat is often needed for views or simple queries where two parts have to be connected to each other. For example, when queries about master data, the first name and surname of a customer are often linked to one another on an invoice using the PL / SQL Concat function.

PL / SQL Concat function syntax

ThePL / SQL Concat function can be incorporated in a select query as follows:

SELECT CONCAT (String1, String2);

The PL / SQL Concat function is used to connect two strings.

PL / SQL Concat function example

Here are some Examples of the Oracle Concat function are listed to show how the Concat function can be used in Oracle PL / SQL.

SELECT CONCAT ('Max', 'Mustermann'); - To connect two strings SELECT CONCAT (CONCAT ('Max', 'von'), 'Mustermann') - To connect three strings

In some cases it is necessary that a large number of strings have to be connected with one another. It is entirely possible to use the Concat function n times, but this is not advantageous. The || operator exists for such cases. Here is a small example ...

SELECT CONCAT (CONCAT (CONCAT (CONCAT (CONCAT (CONCAT ('Max', 'from'), 'Mustermann'), 'goes'), 'alone'), 'to'), 'home.') - Example for excessive use of the PL / SQL CONCAT function SELECT 'Max' || 'from' || 'Mustermann' || 'goes' || 'alone' || 'after' || 'Home.' - Example of the more elegant way using the || operator as a CONCAT replacement

Further articles