Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

how to convert number to char in otbi

Received Response

21

Views

2

Comments

Marijana Bilos

Marijana Bilos Rank 1 - Community Starter

Apr 24, 2025 2:09PM in Oracle Transactional Business Intelligence

0

Answers

Hassan El Bouihi-Oracle Rank 6 - Analytics Lead

Apr 24, 2025 2:46PM

Hello Marijana,
The following is an example of converting a number to a char:

CAST("Worker"."Work Terms Assignment ID" AS CHAR(40))
Thank you
Hassan

0
Riyaz Ali-Oracle Rank 6 - Analytics Lead

Apr 25, 2025 3:03AM

You can use TO_CHAR option as well:
sql
TO_CHAR("Table"."Number Column")

0