Skip to content

Coder Tutorial

Menu
  • Home
  • HTML
  • CSS
  • PHP
  • SQL
  • MySQL
  • JS
  • PL/SQL
  • Python
  • Java
  • Oracle
Home
PL/SQL
PL/SQL Chr

PL/SQL Chr

Oracle PL/SQL Chr Function

The chr function returns the character based on the NUMBER code. Is the opposite of the ascii function.

The Chr Function syntax:

chr ( number )

Example:

select chr(97) from dual;
would return a


select chr(65) from dual;
would return A

Tutorials

  • PL/SQL Tutorial
  • PL/SQL Blocks
  • PL/SQL Variables
  • PL/SQL Control structures
  • PL/SQL Collections and Records
  • PL/SQL Cursors
  • PL/SQL Stored Procedures
  • PL/SQL Functions
  • PL/SQL Packages
  • PL/SQL Exception Handling
  • PL/SQL Triggers
  • PL/SQL If-Then-Else Statement
  • PL/SQL For Loop
  • PL/SQL While Loop
  • PL/SQL Case Statement
  • PL/SQL Varray
  • PL/SQL Nested Table
  • PL/SQL Indexed Arrays
  • PL/SQL Record
  • PL/SQL Examples
  • Oracle PL/SQL Functions
  • PL/SQL Interview Questions

Recent Posts

  • Java Polymorphism
  • Java Encapsulation
  • Java Abstraction
  • PostgreSQL ERROR: cannot begin/end transactions in PL/pgSQL
  • PostgreSQL Column must appear in the GROUP BY clause
  • PostgreSQL Column specified more than once
  • PostgreSQL Create database, Alter database examples
  • PostgreSQL Create schema syntax, Alter schema
  • PostgreSQL Create database user, alter and drop username
  • PostgreSQL Alter table name. Modify column name
Coder Tutorial Copyright © 2025. | Privacy Policy
Back to Top ↑
x