How to prevent exponential numbers auto-convert?

[#1]

Hi,

I'm using a application that have a field that contains data set as VARCHAR2, in oracle pl/sql, and when I extract that field some data come like a result in exponential. For example: I have a field that contains a company's ID like 001E2, and I want it to stay that way, but whenever I extract that, or try to transform in text, it always shows 00100...

Thanks for the help.

[lironbaram]

hi you can use text(ID) in the script

[#3]

Thank you for the response, but it doesn't work, I've tried this before post it here... The only way it could be possible is if I contatenate it with another character, then removing it at the load on the others dashboards... It doesn't are nor feel right and I can't change all the others dashboards that use this extraction just for these particular cases...

[#4 · Accepted solution]

I have found how to prevent the conversion of a exponecial number, it was in the release notes from the 11th version. There are a new variable named ExponentNumberNotation that can be set to 0 to ignore the conversion of the exponencials...

This topic can be closed now.

Thank you.