InConditionBuilder

API reference › yii › db › oci › conditions › InConditionBuilder

class	yii\db\oci\conditions\InConditionBuilder
Extends	yii\db\conditions\InConditionBuilder
Implements	yii\db\ExpressionBuilderInterface
Uses traits	yii\db\ExpressionBuilderTrait
Source	framework/db/oci/conditions/InConditionBuilder.php

Builds objects of InCondition.

Properties

Property	Type	Description	Defined by
$queryBuilder protected	yii\db\QueryBuilder	Default: null.	yii\db\ExpressionBuilderTrait

Methods

Method	Description	Defined by
__construct()	ExpressionBuilderTrait constructor.	yii\db\ExpressionBuilderTrait
build()	Method builds the raw SQL from the $expression that will not be additionally escaped or quoted.	InConditionBuilder
buildCompositeInCondition() protected	Builds SQL for composite IN condition.	yii\db\conditions\InConditionBuilder
buildSubqueryInCondition() protected	Builds SQL for IN condition.	yii\db\conditions\InConditionBuilder
buildValues() protected	Builds values to be used in InCondition.	yii\db\conditions\InConditionBuilder
getNotEqualOperator() protected	Returns inequality operator for decomposed NOT IN conditions.	yii\db\conditions\InConditionBuilder
getNullCondition() protected	Builds IS NULL / IS NOT NULL condition for a scalar column based on the operator.	yii\db\conditions\InConditionBuilder
splitCondition() protected	Oracle DBMS does not support more than 1000 parameters in IN condition.	InConditionBuilder

Method details

build()

public function build(yii\db\ExpressionInterface|yii\db\conditions\InCondition $expression, array &$params = []): string

Method builds the raw SQL from the $expression that will not be additionally escaped or quoted.

Parameters

Parameter	Type	Description
$expression	yii\db\ExpressionInterface|yii\db\conditions\InCondition	The expression to be built.
$params	array	The binding parameters.

Returns

string: The raw SQL that will not be additionally escaped or quoted.

splitCondition()

protected function splitCondition(yii\db\conditions\InCondition $condition, array &$params): string|null

Oracle DBMS does not support more than 1000 parameters in IN condition.

This method splits long IN condition into series of smaller ones.

Parameters

Parameter	Type	Description
$condition	yii\db\conditions\InCondition	The expression to be built.
$params	array	The binding parameters.

Returns

string|null: Null when split is not required. Otherwise - built SQL condition.