nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

how to convert number to char in otbi

Find more posts tagged with

Accepted answers

All comments

Hassan El Bouihi-Oracle

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

Riyaz Ali-Oracle

You can use TO_CHAR option as well:

sql
TO_CHAR("Table"."Number Column")