Skip to Main Content

SQL & PL/SQL

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!

How to add ordinality (st, nd, rd, th) to numbers?

Chandu VenuOct 8 2021

Hello,
Create Table T1_Temp(P_ID number,PC_ID number);
insert into T1_TEMP values (1,null);
insert into T1_TEMP values (2,null);
insert into T1_TEMP values (23,null);
insert into T1_TEMP values (44,null);
Oracle DB Version: Oracle 19c (Enterprise Edition Release 19.0.0.0.0)
I have numbers like:
image.pngI am looking for ouput as:
image.pngHow can I add ordinality (st, nd, rd, th) to numbers on my table? Any help is greatly appreciated.

Thanks.

This post has been answered by mathguy on Oct 8 2021
Jump to Answer

Comments

Post Details

Added on Oct 8 2021
8 comments
1,805 views