Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
DBIx::Class::SQLMaker:UsercContributed PeDBIx::Class::SQLMaker::OracleJoins(3)

NAME
       DBIx::Class::SQLMaker::OracleJoins - Pre-ANSI Joins-via-Where-Clause
       Syntax

PURPOSE
       This module is used with	Oracle < 9.0 due to lack of support for
       standard	ANSI join syntax.

SYNOPSIS
       Not intended for	use directly; used as the sql_maker_class for schemas
       and components.

DESCRIPTION
       Implements pre-ANSI joins specified in the where	clause.	 Instead of:

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

       It will write:

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

       It should properly support left joins, and right	joins.	Full outer
       joins are not possible due to the fact that Oracle requires the entire
       query be	written	to union the results of	a left and right join, and by
       the time	this module is called to create	the where query	and table
       definition part of the sql query, it's already too late.

METHODS
       select
	   Overrides DBIx::Class::SQLMaker's select() method, which calls
	   _oracle_joins() to modify the column	and table list before calling
	   next::method().

BUGS
       Does not	support	full outer joins (however neither really does DBIC
       itself)

SEE ALSO
       DBIx::Class::Storage::DBI::Oracle::WhereJoins - Storage class using
       this
       DBIx::Class::SQLMaker - Parent module
       DBIx::Class - Duh

FURTHER	QUESTIONS?
       Check the list of additional DBIC resources.

COPYRIGHT AND LICENSE
       This module is free software copyright by the DBIx::Class (DBIC)
       authors.	You can	redistribute it	and/or modify it under the same	terms
       as the DBIx::Class library.

perl v5.32.1			  2020-03DBIx::Class::SQLMaker::OracleJoins(3)

NAME | PURPOSE | SYNOPSIS | DESCRIPTION | METHODS | BUGS | SEE ALSO | FURTHER QUESTIONS? | COPYRIGHT AND LICENSE

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=DBIx::Class::SQLMaker::OracleJoins&sektion=3&manpath=FreeBSD+13.0-RELEASE+and+Ports>

home | help