Is your feature request related to a problem? Please describe.

This issue is originated from #3741. In that issue, the author suggests to add "db2, firebird, mysql, odbc, oracle and PostgreSQL" but only one PR #5029 responds to this which only added PostgreSQL, and the issue was closed.
Currently, in ports/soci/portfile.cmake:

vcpkg_check_features(OUT_FEATURE_OPTIONS options
    FEATURES
        boost       WITH_BOOST
        boost       CMAKE_REQUIRE_FIND_PACKAGE_Boost
        empty       SOCI_EMPTY
        mysql       WITH_MYSQL
        odbc        WITH_ODBC
        odbc        CMAKE_REQUIRE_FIND_PACKAGE_ODBC
        postgresql  WITH_POSTGRESQL
        sqlite3     WITH_SQLITE3
    INVERTED_FEATURES
        core        WITH_DB2
        core        WITH_FIREBIRD
        core        WITH_ORACLE
        core        WITH_VALGRIND
)

Only MySQL, odbc, and sqlite3 are enabled, while oracle is disabled.

Proposed solution

SOCI is expected to enable Oracle by setting WITH_ORACLE to true in cmake.

Describe alternatives you've considered

No response

Additional context

No response