Class yii\db\oci\conditions\InConditionBuilder
Protected Properties
| Property | Type | Description | Defined By |
|---|---|---|---|
| $queryBuilder | yii\db\QueryBuilder | yii\db\ExpressionBuilderTrait |
Public 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. | yii\db\oci\conditions\InConditionBuilder |
Protected Methods
| Method | Description | Defined By |
|---|---|---|
| buildCompositeInCondition() | Builds SQL for IN condition. | yii\db\conditions\InConditionBuilder |
| buildSubqueryInCondition() | Builds SQL for IN condition. | yii\db\conditions\InConditionBuilder |
| buildValues() | Builds $values to be used in yii\db\conditions\InCondition | yii\db\conditions\InConditionBuilder |
| getNullCondition() | Builds is null/is not null condition for column based on operator | yii\db\conditions\InConditionBuilder |
| getRawValuesFromTraversableObject() | yii\db\conditions\InConditionBuilder | |
| splitCondition() | Oracle DBMS does not support more than 1000 parameters in IN condition. |
yii\db\oci\conditions\InConditionBuilder |
Method Details
Method builds the raw SQL from the $expression that will not be additionally escaped or quoted.
| public string build ( yii\db\ExpressionInterface $expression, array &$params = [] ) | ||
| $expression | yii\db\ExpressionInterface|yii\db\conditions\InCondition | The expression to be built. |
| $params | array | The binding parameters. |
| return | string | The raw SQL that will not be additionally escaped or quoted. |
|---|---|---|
Oracle DBMS does not support more than 1000 parameters in IN condition.
This method splits long IN condition into series of smaller ones.
| protected string|null splitCondition ( yii\db\conditions\InCondition $condition, &$params ) | ||
| $condition | yii\db\ExpressionInterface|yii\db\conditions\InCondition | The expression to be built. |
| $params | array | The binding parameters. |
| return | string|null | Null when split is not required. Otherwise - built SQL condition. |
|---|---|---|