@aseelodeh,
I believe this depends on your Oracle DB and what features are enabled. If you have REST Services for Oracle DB enabled then you'll want to look at Oracle's docs. The following link is to the REST Services info for Oracle r19.
https://docs.oracle.com/en/database/oracle/oracle-database/19/dbrst/index.htmlWe don't have an existing asset for encapsulating REST access to Oracle DB's. We do have an asset that leverages the Oracle Managed Access Provider though.
Is there a specific reason you're trying to with Oracle DB via REST?
Cheers,
Eric