Hi Raja •,
Welcome to Microsoft Q&A forum.
As I understand, you want to migrate on-premise Oracle to Azure SQL Database.
You can use SSMA SQL Server Migration Assistant for this purpose which will do an assessment, validation of data types, conversion before migration.
For step-by-step guide refer to the standard documentation here:
Hope this helps.
Let us know if you face any issue in doing the same.
Thanks