I need to remove the slash from the date , i am using below query to get the Output.

SELECT ‘AB-‘||a.store_no||’-‘||a.created_date
FROM ORDER_STORE a;

The output coming as: AB-285485-08/15/2024
I need output as : AB-285485-15AUG2024

Please modify the query above to get the required output as below
I need output as : AB-285485-15AUG2024

Need to Remove the slash and also i need to change date 08/15/2024 to 15AUG2024