How do I convert a SQL Server Date MM/DD/CCYY to an Oracle Date formatted as NUMBER(8,0)

My Mistake. I have put a "-". Please try below

SELECT replace(convert(VARCHAR, getdate(), 111) , '/', '') 

---

Please click "Mark as Answer" if the post solves your problem - Thanks