Skip to Main Content

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!

Full numbers label value in Oracle APEX charts

SinghaBFeb 10 2019 — edited Mar 13 2019

Hi can we have the full numbers as labels in Bar charts.

For example if we have 3000 as the label value coming from the query its showing 3K in the bar charts.. In the attached image the label value is showing 21K. I want it as 21000. Any suggestions.

In the Capture.JPG

Comments

contemplator

It's funny that the day before, I get stumped by a problem the whole day... then the next day I find the answer to my problem.

The view is actually working. but the last record is not appearing. This is the same for my tables. no last record.

I get 3 rows in the table in the SQL Command Line.

I get 2 rows in the view in the SQL Command Line.

I get 2 rows in the table in the PHP Web page.

I get 1 row in the view in the PHP Web page.

I have only changed the select statement, the rest of the code is the same.

help?

contemplator

OK, I have just figured it out.

Oracle 11g XE allows for one session. Connecting to Oracle through PHP counts as a session.

Disconnecting the console fixed the problem.

Christopher Jones-Oracle

You can have more than one session at a time to XE.  At a guess, you hadn't committed in the first session and disconnecting performed the commit for you.  This let the other session see the data.

1 - 3

Post Details

Added on Feb 10 2019
5 comments
3,247 views