MySQL CASE() Function

PLSQL | COMPOSE Function

Last Updated : 19 Sep, 2019

The string in PL/SQL is actually a sequence of characters with an optional size specification. The characters could be numeric, letters, blank, special characters or a combination of all. The Compose Function in PLSQL is used to return a Unicode string. The unistring values that can be combined with other characters in the compose function are:

unistr('\0300') - grave accent ( ` )
unistr('\0301') - acute accent ( ´ )
unistr('\0302') - circumflex ( ^ )
unistr('\0303') - tilde ( ~ )
unistr('\0308') - umlaut ( ¨ )

Syntax:

COMPOSE( string )

Parameters Used: string - It is used to specify the input value whose Unicode string needs to be created. Supported Versions of Oracle/PLSQL:

Oracle 12c
Oracle 11g
Oracle 10g
Oracle 9i

Example:

DECLARE 
   Test_Char char := 'a';
   Test_Char2 char := 'e';
   
BEGIN 
   dbms_output.put_line(COMPOSE(Test_Char || unistr('\0308' ))); 
   dbms_output.put_line(COMPOSE(Test_Char || unistr('\0301' )));
   dbms_output.put_line(COMPOSE(Test_Char || unistr('\0303' ))); 
   dbms_output.put_line(COMPOSE(Test_Char2 || unistr('\0302' ))); 
   
END;

Output:

ä
á
ã
ê

MySQL CASE() Function

S

Shubrodeep Banerjee

Improve

Article Tags :

Similar Reads

PLSQL | DECOMPOSE Function

The DECOMPOSE Function in PLSQL is used for accepting a string and returning its Unicode string. The DECOMPOSE Function is generally the opposite of the COMPOSE function. The DECOMPOSE function is valid only for Unicode characters and it returns a Unicode string after decomposition in the same chara

MySQL | COMPRESS( ) Function

The MySQL COMPRESS() function is used for the compression of a string. The value returned by the COMPRESS() function is a binary string. The COMPRESS() function stores non-empty strings as a four-byte length of the uncompressed string, which is then followed by the compressed string. If the string e

PLSQL | CONCAT Function

The string in PL/SQL is actually a sequence of characters with an optional size specification. The characters could be numeric, letters, blank, special characters or a combination of all. The CONCAT function allows you to concatenate two strings together. To CONCAT more than two values, we can nest

MySQL CASE() Function

MySQL CASE function is a conditional statement that returns a value when the first condition is met. Once a condition is met, the CASE function does not check for other conditions. If no condition is met it returns the output in ELSE part. CASE Function in MySQLThe CASE Function in MySQL allows usin

MySQL COALESCE() Function

The MySQL COALESCE() function returns the first non-null value in a list of expressions. COALESCE function in MySQLThe COALESCE function in MySQL is used to get the first non-null value from a list of expressions. If all the values in the list are evaluated to NULL, then the COALESCE() function retu

PL/SQL Functions

PL/SQL functions are reusable blocks of code that can be used to perform specific tasks. They are similar to procedures but must always return a value. A function in PL/SQL contains:Function Header: The function header includes the function name and an optional parameter list. It is the first part o

MySQL | CONVERT( ) Function

The MySQL CONVERT() function is used for converting a value from one datatype to a different datatype. The MySQL CONVERT() function is also used for converting a value from one character set to another character set. It accepts two parameters which are the input value and the type to be converted in

PLSQL | MOD Function

The MOD function is an inbuilt function in PLSQL which is used to return the remainder when a is divided by b. Its formula is m - n * \left\lfloor\dfrac{m}{n}\right\rfloor. Syntax: MOD(a, b) Parameters Used: This function accepts two parameters a and b. This function gives remainder as the output wh

PLSQL | BITAND Function

The BITAND is an inbuilt function in PLSQL which is used to returns an integer value which is calculated with AND operation of two given input decimal number. Internally these input decimal numbers get converted into binary numbers and then AND operation is performed and results are returned as outp

PLSQL | TAN Function

The TAN function is an inbuilt function in PLSQL which is used to return the tangent of an input number. The tangent is a trigonometric function of an angle and here the input number is the angle expressed in the form of radians. 180 degree is equal to pi radian. Syntax: TAN( number ) Parameters Use