createQueryBuilder() public method Creates a query builder for the database. This method may be overridden by child classes to create a DBMS-specific query builder. public yii\db\QueryBuilder createQueryBuilder ( )return yii\db\QueryBuilder Query builder instance

createColumnSchemaBuilder() public method Create a column schema builder instance giving the type and value precision. This method may be overridden by child classes to create a DBMS-specific column schema builder. public yii\db\ColumnSchemaBuilder createColumnSchemaBuilder ( $type, $length = null )$type string Type of the column. See yii\db\oci\ColumnSchemaBuilder::$type. $length integer|string|array Length or precision of the column. See yii\db\oci\ColumnSchemaBuilder::$length. re

createColumn() protected method Creates ColumnSchema instance protected yii\db\ColumnSchema createColumn ( $column )$column array

$lastInsertID public read-only property The row ID of the last row inserted, or the last value retrieved from the sequence object public string getLastInsertID ( $sequenceName = '' )

$exceptionMap public property Map of DB errors and corresponding exceptions If left part is found in DB error message exception class from the right part is used. public array $exceptionMap = ['ORA-00001: unique constraint' => 'yii\db\IntegrityException']

selectExists() public method (available since version 2.0.8) Creates a SELECT EXISTS() SQL statement. public string selectExists ( $rawSql )$rawSql string The subquery in a raw form to select from. return string The SELECT EXISTS() SQL statement.

resetSequence() public method Creates a SQL statement for resetting the sequence value of a table's primary key. The sequence will be reset such that the primary key of the next new row inserted will have the specified value or 1. public string resetSequence ( $table, $value = null )$table string The name of the table whose primary key sequence will be reset $value array|string The value for the primary key of the next new row inserted. If this is not set, the next new row's primary

renameTable() public method Builds a SQL statement for renaming a DB table. public string renameTable ( $table, $newName )$table string The table to be renamed. The name will be properly quoted by the method. $newName string The new table name. The name will be properly quoted by the method. return string The SQL statement for renaming a DB table.

insert() public method Creates an INSERT SQL statement. For example, $sql = $queryBuilder->insert('user', [ 'name' => 'Sam', 'age' => 30, ], $params); The method will properly escape the table and column names. public string insert ( $table, $columns, &$params )$table string The table that new rows will be inserted into. $columns array The column data (name => value) to be inserted into the table. $params array The binding parameters that will be generated by

dropIndex() public method Builds a SQL statement for dropping an index. public string dropIndex ( $name, $table )$name string The name of the index to be dropped. The name will be properly quoted by the method. $table string The table whose index is to be dropped. The name will be properly quoted by the method. return string The SQL statement for dropping an index.