Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Oracle - PL/SQL - ASCII Function

In Oracle/PLSQL, the ascii function returns the NUMBER code that represents the specified character.

The syntax for the ascii function is:

ascii( single_character )

single_character is the specified character to retrieve the NUMBER code for. If more than one character is entered, the function will return the value for the first character and ignore all of the characters after the first.

Applies To:

  • Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g

For example:

ascii('t')

would return 116.

ascii('T')

would return 84.

ascii('T2')

would also return 84.

KNOWN IS A DROP UNKNOWN IS AN OCEAN


This post first appeared on ORACLE LEARNINGS, please read the originial post: here

Share the post

Oracle - PL/SQL - ASCII Function

×

Subscribe to Oracle Learnings

Get updates delivered right to your inbox!

Thank you for your subscription

×