Class Phalcon\Db\Dialect\Oracle

extends abstract class Phalcon\Db\Dialect

implements Phalcon\Db\DialectInterface

Generates database specific SQL for the Oracle RDBMS

Methods

public limit (unknown $sqlQuery, unknown $number)

Generates the SQL for LIMIT clause

public getColumnDefinition (unknown $column)

Gets the column name in Oracle

public addColumn (unknown $tableName, unknown $schemaName, unknown $column)

Generates SQL to add a column to a table

public modifyColumn (unknown $tableName, unknown $schemaName, unknown $column, [unknown $currentColumn])

Generates SQL to modify a column in a table

public dropColumn (unknown $tableName, unknown $schemaName, unknown $columnName)

Generates SQL to delete a column from a table

public addIndex (unknown $tableName, unknown $schemaName, unknown $index)

Generates SQL to add an index to a table

public dropIndex (unknown $tableName, unknown $schemaName, unknown $indexName)

/** /** Generates SQL to delete an index from a table

public addPrimaryKey (unknown $tableName, unknown $schemaName, unknown $index)

Generates SQL to add the primary key to a table

public dropPrimaryKey (unknown $tableName, unknown $schemaName)

Generates SQL to delete primary key from a table

public addForeignKey (unknown $tableName, unknown $schemaName, unknown $reference)

Generates SQL to add an index to a table

public dropForeignKey (unknown $tableName, unknown $schemaName, unknown $referenceName)

Generates SQL to delete a foreign key from a table

public createTable (unknown $tableName, unknown $schemaName, unknown $definition)

Generates SQL to create a table in Oracle

public dropTable (unknown $tableName, unknown $schemaName, [unknown $ifExists])

Generates SQL to drop a table

public createView (unknown $viewName, unknown $definition, [unknown $schemaName])

Generates SQL to create a view

public dropView (unknown $viewName, [unknown $schemaName], [unknown $ifExists])

Generates SQL to drop a view

public viewExists (unknown $viewName, [unknown $schemaName])

Generates SQL checking for the existence of a schema.view

public listViews ([unknown $schemaName])

Generates the SQL to list all views of a schema or user

public tableExists (unknown $tableName, [unknown $schemaName])

Generates SQL checking for the existence of a schema.table

<?php

    echo $dialect->tableExists("posts", "blog");
    echo $dialect->tableExists("posts");

public describeColumns (unknown $table, [unknown $schema])

Generates SQL describing a table

<?php

    print_r($dialect->describeColumns("posts"));

public listTables ([unknown $schemaName])

List all tables in database

<?php

    print_r($dialect->listTables("blog"))

public describeIndexes (unknown $table, [unknown $schema])

Generates SQL to query indexes on a table

public describeReferences (unknown $table, [unknown $schema])

Generates SQL to query foreign keys on a table

public tableOptions (unknown $table, [unknown $schema])

Generates the SQL to describe the table creation options

public supportsSavepoints ()

Checks whether the platform supports savepoints

public supportsReleaseSavepoints ()

Checks whether the platform supports releasing savepoints.

public registerCustomFunction (unknown $name, unknown $customFunction) inherited from Phalcon\Db\Dialect

Registers custom SQL functions

public getCustomFunctions () inherited from Phalcon\Db\Dialect

Returns registered functions

final public escape (unknown $str, [unknown $escapeChar]) inherited from Phalcon\Db\Dialect

Escape identifiers

public forUpdate (unknown $sqlQuery) inherited from Phalcon\Db\Dialect

Returns a SQL modified with a FOR UPDATE clause

<?php

 $sql = $dialect->forUpdate('SELECT * FROM robots');
 echo $sql; // SELECT * FROM robots FOR UPDATE

public sharedLock (unknown $sqlQuery) inherited from Phalcon\Db\Dialect

Returns a SQL modified with a LOCK IN SHARE MODE clause

<?php

 $sql = $dialect->sharedLock('SELECT * FROM robots');
 echo $sql; // SELECT * FROM robots LOCK IN SHARE MODE

final public getColumnList (unknown $columnList, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect

Gets a list of columns with escaped identifiers

<?php

    echo $dialect->getColumnList(array('column1', 'column'));

final public getSqlColumn (unknown $column, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect

Resolve Column expressions

public getSqlExpression (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect

Transforms an intermediate representation for a expression into a database system valid expression

final public getSqlTable (unknown $table, [unknown $escapeChar]) inherited from Phalcon\Db\Dialect

Transform an intermediate representation of a schema/table into a database system valid expression

public select (unknown $definition) inherited from Phalcon\Db\Dialect

Builds a SELECT statement

public createSavepoint (unknown $name) inherited from Phalcon\Db\Dialect

Generate SQL to create a new savepoint

public releaseSavepoint (unknown $name) inherited from Phalcon\Db\Dialect

Generate SQL to release a savepoint

public rollbackSavepoint (unknown $name) inherited from Phalcon\Db\Dialect

Generate SQL to rollback a savepoint

final protected getSqlExpressionScalar (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect

Resolve Column expressions

final protected getSqlExpressionObject (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect

Resolve object expressions

final protected getSqlExpressionQualified (unknown $expression, [unknown $escapeChar]) inherited from Phalcon\Db\Dialect

Resolve qualified expressions

final protected getSqlExpressionBinaryOperations (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect

Resolve binary operations expressions

final protected getSqlExpressionUnaryOperations (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect

Resolve unary operations expressions

final protected getSqlExpressionFunctionCall (unknown $expression, unknown $escapeChar, [unknown $bindCounts]) inherited from Phalcon\Db\Dialect

Resolve function calls

final protected getSqlExpressionList (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect

Resolve Lists

final protected getSqlExpressionAll (unknown $expression, [unknown $escapeChar]) inherited from Phalcon\Db\Dialect

Resolve *

final protected getSqlExpressionCastValue (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect

Resolve CAST of values

final protected getSqlExpressionConvertValue (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect

Resolve CONVERT of values encodings

final protected getSqlExpressionCase (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect

Resolve CASE expressions

final protected getSqlExpressionFrom (unknown $expression, [unknown $escapeChar]) inherited from Phalcon\Db\Dialect

Resolve a FROM clause

final protected getSqlExpressionJoins (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect

Resolve a JOINs clause

final protected getSqlExpressionWhere (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect

Resolve a WHERE clause

final protected getSqlExpressionGroupBy (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect

Resolve a GROUP BY clause

final protected getSqlExpressionHaving (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect

Resolve a HAVING clause

final protected getSqlExpressionOrderBy (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect

Resolve a ORDER BY clause

final protected getSqlExpressionLimit (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect

Resolve a LIMIT clause

protected prepareColumnAlias (unknown $qualified, [unknown $alias], [unknown $escapeChar]) inherited from Phalcon\Db\Dialect

Prepares column for this RDBMS

protected prepareTable (unknown $table, [unknown $schema], [unknown $alias], [unknown $escapeChar]) inherited from Phalcon\Db\Dialect

Prepares table for this RDBMS

protected prepareQualified (unknown $column, [unknown $domain], [unknown $escapeChar]) inherited from Phalcon\Db\Dialect

Prepares qualified for this RDBMS