• 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 ASCIISTR Function

Oracle ASCIISTR Function

November 23, 2012 by techhoneyadmin

Oracle ASCIIStr FunctionOracle ASCIIStr Function is used to convert a string in any character set to ASCII String. Syntax and examples of using the ASCIIStr Function are listed below.


Oracle ASCIISTR Function Syntax

SELECT ASCIIStr (string)
FROM table_name;

Oracle ASCIISTR Function – Use with SQL SELECT Statement Example

Oracle ASCIISTR Function is used with the SQL SELECT Statement.

For example, the SQL ASCIISTR Function query below returns the ASCII String value of the string passed.

SELECT ASCIIStr ('Tech Honey')
FROM dual;

The above SQL SELECT Query will return ‘Tech Honey’ as the ASCII String value for ‘Tech Honey’


Oracle ASCIISTR Function – Use with Special Characters Example

Oracle ASCIISTR Function can be used with special characters.

For example, the SQL ASCIISTR Function query below returns the ASCII String format for the string passed.

SELECT ASCIIStr ('Tech Honey Ä Ê Õ Ø')
FROM dual;

The above SQL SELECT Query will return ‘Tech Honey \00C4 \00CA \00D5 \00D8’ as the ASCII String value for ‘’Tech Honey Ä Ê Õ Ø’’


Filed Under: function Tagged With: ASCIISTRPLSQL, how to convert String to ASCII in oracle plsql, How to use ASCIISTR function in oracle sql plsql with example, What is ASCIISTR function in oracle sql plsql

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