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

Please check this?

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

---

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