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 New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
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

25

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