APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle apex not displaying leading zero

Arun2912Jul 10 2018 — edited Jul 10 2018

I have this strange thing happening.

I have a table where i have data with leading zero's for a column(number type). When i query in apex - SQL Workshop

Select colA from tab1; the output is giving as .87,

but when i'm querying the same in SQL developer i'm getting 0.87

I'm not sure where the leading zero's are going when checking in Apex. Are there any setting i have to change?We are using Apex 3.2 version.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 7 2018

Added on Jul 10 2018

#apex-discussions

7 comments

795 views