How do I cast a NUMBER value to a single CHAR in Oracle? How do I cast a NUMBER value to a single CHAR in Oracle? oracle oracle

How do I cast a NUMBER value to a single CHAR in Oracle?


oracle casting plsql char int

As per my comment on @northpole's answer...

The closest to what you want might not be exactly correct but the CHR function would convert the numeric to it's ascii equivalent.
i.e. alpha := chr(113); would put the char "q" into the alpha variable thereby storing your numeric "113" as a single byte.

oracle casting plsql char int

You have a couple options. You can use TO_CHAR and do something like:

TO_CHAR(rank,'99')

Or use the CAST function and fix your attempt by providing a larger CHAR:

CAST(rank as CHAR(2))

The reason for that is as Ollie described in his comment.

oracle casting plsql char int

You could try this:

SUBSTR(CAST(rank as CHAR(2)), 2, 1)

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last