Hi. I have a sharepoint 2016 site. I would like to retieve data from SQL/Oracle database and show the datatable information as a table in a webpart page.
You need to find a programming language that offers an Oracle SQL driver or can interact with an Oracle SQL driver, i.e. .NET, though you can do .NET development with VS Code rather than the full VS IDE.
You would still need to host the resulting middleware on a server or service, though.
If the response is helpful, please click "Accept Answer" and upvote it.