Skip to Main Content

PeopleSoft Enterprise

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!

NumberToString and NumberToDisplayString

User_OLCAWJul 28 2020 — edited Jul 28 2020

Both NumberToString and NujmberToDisplayString have the same syntax.  I got the same result in an AE program:

    MessageBox(0, "", 0, 0, NumberToDisplayString("%10.2v", 12345.6));       --> 12,345.60

    MessageBox(0, "", 0, 0, NumberToString("%10.2v", 12345.6));                  --> 12,345.60

What is the difference between these two functions?

This post has been answered by Velu Angusamy on Jul 28 2020
Jump to Answer

Comments

momy momy

mark

user_2DKLA

@User_T9GS1: “Table comment” is not the proper term for what you ask here: what you're showing above are pieces of information (column name, data type, maximum length, possibility of NULL values, etc.) excerpted from the description of columns in SQL queries. That information is available in cursor metadata, and yes, exposing it would be nice.

Maybe in SQL Developer Next?

Regards,

thatJeffSmith-Oracle

Interesting idea. It would have to be done on a separate thread as to not slow down the execution time for the query itself…but yeah, interesting.

1 - 3

Post Details

Added on Jul 28 2020
2 comments
32 views