• Skip to primary navigation
  • Skip to main content

Tech Honey

The #1 Website for Oracle PL/SQL, OA Framework and HTML

  • Home
  • HTML
    • Tags in HTML
    • HTML Attributes
  • OA Framework
    • Item in OAF
    • Regions in OAF
    • General OAF Topics
  • Oracle
    • statement
    • function
    • clause
    • plsql
    • sql
You are here: Home / Oracle / function / Oracle DECOMPOSE Function

Oracle DECOMPOSE Function

November 24, 2012 by techhoneyadmin

Oracle DECOMPOSE FunctionOracle DECOMPOSE Function is be used to convert a string to a UNICODE string. Syntax and examples of SQL DECOMPOSE Function are listed below.


Oracle DECOMPOSE Function Syntax

SELECT DECOMPOSE (string_1)
 FROM table_name;

In the above syntax the “string_1” is the string to be decomposed


Oracle DECOMPOSE Function – Use in SQL SELECT Statement Examples

Oracle/DECOMPOSE Function is used with the SQL SELECT Statement.

For example, the SQL query below returns a UNICODE string of the string passed.

SELECT DECOMPOSE('Tèch Honèy')
FROM dual;

The above SQL query returns ‘Tèch Honèy’.


Oracle DECOMPOSE Function – Use with Single Word Example

The below SQL query returns the UNICODE String of the string passed.

SELECT DECOMPOSE('olé')
FROM dual;

The above SQL query returns ‘ole´’


Filed Under: function Tagged With: DECOMPOSE Function in oracle plsql, DECOMPOSE Function in oracle sql, DECOMPOSEPLSQL, how to use DECOMPOSE Function in oracle database query, how to use DECOMPOSE Function in oracle plsql, how to use DECOMPOSE Function in oracle sql, syntax and example of DECOMPOSE Function in oracle database query, syntax and example of DECOMPOSE Function in oracle plsql, syntax and example of DECOMPOSE Function in oracle sql, using DECOMPOSE Function in oracle database query, using DECOMPOSE Function in oracle plsql, using DECOMPOSE Function in oracle sql

Copyright © 2023 · Parallax Pro on Genesis Framework · WordPress · Log in