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:
I am looking for ouput as:
How can I add ordinality (st, nd, rd, th) to numbers on my table? Any help is greatly appreciated.
Thanks.