• 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 / TO_SINGLE_BYTE Function in Oracle SQL – PLSQL

TO_SINGLE_BYTE Function in Oracle SQL – PLSQL

November 6, 2012 by techhoneyadmin

The TO_SINGLE_BYTE function in Oracle SQL / PLSQL is used to get a character value with all the multi byte characters converted to single byte characters.

To use TO_SINGLE_BYTE function make sure that the data base contains both single and multi byte characters.

The Syntax for the TO_SINGLE_BYTE function in Oracle SQL / PLSQL is:

SEELECT TO_SINGLE_BYTE(character1)
FROM table_name;

  • character1 can be of any type like char, varchar2, nchar or nvarchar2
  • The return type of TO_SINGLE_BYTE function will be of the same data type as that of the character1.

Example 1:

SELECT TO_SINGLE_BYTE ('Tech Honey')
FROM DUAL;

Will return the single byte character value of ‘Tech Honey’


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

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