Issue:
Solution:
Sort Numbers Only
ORDER BY REGEXP_REPLACE(<COLUMN_NAME>, '[[:digit:]]', '~') ASC;
Sort Numbers and Text
ORDER BY REGEXP_REPLACE(<COLUMN_NAME>, '[[:digit:]]', '~') DESC, REGEXP_REPLACE(<COLUMN_NAME>, '[[:alpha:]]', '~') DESC;
[FndWindowRegistration("YVVDA_COMPANY_ADDR", "YvvdaCompanyAddr", FndWindowRegistrationFlags.HomePage)] [FndDynamicTabPage("frmCompanyAddr...
Example 1: SELECT DISTINCT LISTAGG(t.commission_receiver, ';') WITHIN GROUP (ORDER BY t.commission_receiver) FROM...
FUNCTION Strip_Ora_Error ( sqlerrm_ IN VARCHAR2, sqlcode_ IN NUMBER DEFAULT NULL, strip_ora_only_ IN BOOLEAN DEFAULT...
Comments