/ 
DBIO-Oracle-0.900000
/ DBIO::Oracle::Storage::WhereJoins

NAME

DBIO::Oracle::Storage::WhereJoins - Oracle joins in WHERE syntax support (instead of ANSI).

VERSION

version 0.900000

DESCRIPTION

DBIO::Oracle::Storage subclass for Oracle databases older than version 9.0 that do not support standard ANSI JOIN ... ON syntax.

Instead of:

SELECT x FROM y JOIN z ON y.id = z.id

This storage generates:

SELECT x FROM y, z WHERE y.id = z.id

Left and right outer joins are supported via Oracle's (+) syntax. Full outer joins are not supported because Oracle requires a UNION of left and right joins, which cannot be constructed at the WHERE-clause stage.

DBIO autodetects the Oracle version and uses this storage automatically for pre-9.0 servers. See DBIO::Oracle::SQLMaker::Joins for the SQL generation details.

SEE ALSO

AUTHOR

DBIO & DBIx::Class Authors

COPYRIGHT AND LICENSE

Copyright (C) 2026 DBIO Authors Portions Copyright (C) 2005-2025 DBIx::Class Authors Based on DBIx::Class, heavily modified.

This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.