Hi @Kumar ,
Thank you for posting query in Microsoft Q&A Platform.
You want to load data from Oracle to Some cloud database table? If yes, then there is something called copy activity inside azure data factory which we have to use.
Not sure why, you want to take data from script activity to outside. It should like use copy activity and under source tab use Oracle dataset and under sink tab use your destination database table. Thats it. With that your job done.
Please note, ADF is ETL service. It helps to perform data movement and transformations.
Once your pipeline created you can schedule it with triggers.
Please check below copy activity video to understand it better.
https://www.youtube.com/watch?v=XOJeyRBXBos
Hope this helps. Please let me know how it goes.