Oracle DB query

Unfortunately I don't have any example for Oracle, but see the following one (for MSSQL):

<Input mssql_datetimeoffset>
    Module              im_odbc
    ConnectionString    Driver={ODBC Driver 17 for SQL Server}; Server=MSSQL-HOST; \
                        Trusted_Connection=yes; Database=TESTDB
    IdType  integer
    SQL     SELECT RecordID AS id, \
                   CAST(LogTime AS datetime2) AS EventTime, \
                   DATEPART(tz, LogTime) AS TZOffset, \
                   Message \
              FROM dbo.test1 WHERE RecordID > ?
    Exec    rename_field($id, $RecordID);
</Input>

You just need to find out what's the ConnectionString that suits you. You will find info about that in the documentation provided by the ODBC driver's manufacturer.

This is for your reference...

https://www.connectionstrings.com