dropCommentFromTable() public method (available since version 2.0.8) Builds a SQL command for adding comment to table public string dropCommentFromTable ( $table )$table string The table whose column is to be commented. The table name will be properly quoted by the method. return string The SQL statement for adding comment on column

dropCommentFromColumn() public method (available since version 2.0.8) Builds a SQL command for adding comment to column public string dropCommentFromColumn ( $table, $column )$table string The table whose column is to be commented. The table name will be properly quoted by the method. $column string The name of the column to be commented. The column name will be properly quoted by the method. return string The SQL statement for adding comment on column

buildOrderByAndLimit() public method Builds the ORDER BY and LIMIT/OFFSET clauses and appends them to the given SQL. public string buildOrderByAndLimit ( $sql, $orderBy, $limit, $offset )$sql string The existing SQL (without ORDER BY/LIMIT/OFFSET) $orderBy array The order by columns. See \yii\db\oci\Query::orderBy for more details on how to specify this parameter. $limit integer The limit number. See \yii\db\oci\Query::limit for more details. $offset integer The offset number. See

batchInsert() public method Generates a batch INSERT SQL statement. For example, $sql = $queryBuilder->batchInsert('user', ['name', 'age'], [ ['Tom', 30], ['Jane', 20], ['Linda', 25], ]); Note that the values in each row must match the corresponding column names. public string batchInsert ( $table, $columns, $rows )$table string The table that new rows will be inserted into. $columns array The column names $rows array The rows to be batch inserted into the table retu

alterColumn() public method Builds a SQL statement for changing the definition of a column. public string alterColumn ( $table, $column, $type )$table string The table whose column is to be changed. The table name will be properly quoted by the method. $column string The name of the column to be changed. The name will be properly quoted by the method. $type string The new column type. The getColumnType() method will be invoked to convert abstract column type (if any) into the physica

addForeignKey() public method Builds a SQL statement for adding a foreign key constraint to an existing table. The method will properly quote the table and column names. public string addForeignKey ( $name, $table, $columns, $refTable, $refColumns, $delete = null, $update = null )$name string The name of the foreign key constraint. $table string The table that the foreign key constraint will be added to. $columns string|array The name of the column to that the constraint will be ad

$typeMap public property Mapping from abstract column types (keys) to physical column types (values). public array $typeMap = [\yii\db\oci\Schema::TYPE_PK => 'NUMBER(10) NOT NULL PRIMARY KEY', \yii\db\oci\Schema::TYPE_UPK => 'NUMBER(10) UNSIGNED NOT NULL PRIMARY KEY', \yii\db\oci\Schema::TYPE_BIGPK => 'NUMBER(20) NOT NULL PRIMARY KEY', \yii\db\oci\Schema::TYPE_UBIGPK => 'NUMBER(20) UNSIGNED NOT NULL PRIMARY KEY', \yii\db\oci\Schema::TYPE_CHAR => 'CHAR(1)', \yii\db\oci\Schema

__toString() public method Builds the full string for the column's schema public string __toString ( )

buildUnsignedString() protected method Builds the unsigned string for column. Defaults to unsupported. protected string buildUnsignedString ( )return string A string containing UNSIGNED keyword.

buildFirstString() protected method Builds the first constraint for the column. Defaults to unsupported. protected string buildFirstString ( )return string A string containing the FIRST constraint.