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:
ä
á
ã
ê
Like Article
Suggest improvement
Share your thoughts in the comments
Please Login to comment...