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:
ä á ã ê
Article Tags :