Overview

Namespaces

  • None
  • Yajra
    • Oci8
      • Auth
      • Connectors
      • Eloquent
      • Query
        • Grammars
        • Processors
      • Schema
        • Grammars

Classes

  • OracleGrammar
  • Overview
  • Namespace
  • Class

Class OracleGrammar

Illuminate\Database\Query\Grammars\Grammar
Extended by Yajra\Oci8\Query\Grammars\OracleGrammar uses Yajra\Oci8\OracleReservedWords
Namespace: Yajra\Oci8\Query\Grammars
Located at Oci8/Query/Grammars/OracleGrammar.php
Methods summary
public string
# compileExists( Illuminate\Database\Query\Builder $query )

Compile an exists statement into SQL.

Compile an exists statement into SQL.

Parameters

$query

Returns

string
public string
# compileSelect( Illuminate\Database\Query\Builder $query )

Compile a select query into SQL.

Compile a select query into SQL.

Parameters

$query

Returns

string
protected boolean
# isPaginationable( Illuminate\Database\Query\Builder $query, array $components )

Parameters

$query
$components

Returns

boolean
protected string
# compileAnsiOffset( Illuminate\Database\Query\Builder $query, array $components )

Create a full ANSI offset clause for the query.

Create a full ANSI offset clause for the query.

Parameters

$query
$components

Returns

string
protected string
# compileRowConstraint( Illuminate\Database\Query\Builder $query )

Compile the limit / offset row constraint for a query.

Compile the limit / offset row constraint for a query.

Parameters

$query

Returns

string
protected string
# compileTableExpression( string $sql, string $constraint, Illuminate\Database\Query\Builder $query )

Compile a common table expression for a query.

Compile a common table expression for a query.

Parameters

$sql
$constraint
$query

Returns

string
public array
# compileTruncate( Illuminate\Database\Query\Builder $query )

Compile a truncate table statement into SQL.

Compile a truncate table statement into SQL.

Parameters

$query

Returns

array
public string
# wrapTable( Illuminate\Database\Query\Expression|string $table )

Wrap a table in keyword identifiers.

Wrap a table in keyword identifiers.

Parameters

$table

Returns

string
public string
# getSchemaPrefix( )

Return the schema prefix

Return the schema prefix

Returns

string
public
# setSchemaPrefix( string $prefix )

Set the shema prefix

Set the shema prefix

Parameters

$prefix
public string
# compileInsertGetId( Illuminate\Database\Query\Builder $query, array $values, string $sequence = 'id' )

Compile an insert and get ID statement into SQL.

Compile an insert and get ID statement into SQL.

Parameters

$query
$values
$sequence

Returns

string
public string
# compileInsert( Illuminate\Database\Query\Builder $query, array $values )

Compile an insert statement into SQL.

Compile an insert statement into SQL.

Parameters

$query
$values

Returns

string
public string
# compileInsertLob( Illuminate\Database\Query\Builder $query, array $values, array $binaries, string $sequence = 'id' )

Compile an insert with blob field statement into SQL.

Compile an insert with blob field statement into SQL.

Parameters

$query
$values
$binaries
$sequence

Returns

string
public string
# compileUpdateLob( Illuminate\Database\Query\Builder $query, array $values, array $binaries, string $sequence = 'id' )

Compile an update statement into SQL.

Compile an update statement into SQL.

Parameters

$query
$values
$binaries
$sequence

Returns

string
protected string
# compileLock( Illuminate\Database\Query\Builder $query, boolean|string $value )

Compile the lock into SQL.

Compile the lock into SQL.

Parameters

$query
$value

Returns

string
protected string
# compileLimit( Illuminate\Database\Query\Builder $query, integer $limit )

Compile the "limit" portions of the query.

Compile the "limit" portions of the query.

Parameters

$query
$limit

Returns

string
protected string
# compileOffset( Illuminate\Database\Query\Builder $query, integer $offset )

Compile the "offset" portions of the query.

Compile the "offset" portions of the query.

Parameters

$query
$offset

Returns

string
protected string
# whereDate( Illuminate\Database\Query\Builder $query, array $where )

Compile a "where date" clause.

Compile a "where date" clause.

Parameters

$query
$where

Returns

string
protected string
# dateBasedWhere( string $type, Illuminate\Database\Query\Builder $query, array $where )

Compile a date based where clause.

Compile a date based where clause.

Parameters

$type
$query
$where

Returns

string
protected string
# wrapValue( string $value )

Wrap a single string in keyword identifiers.

Wrap a single string in keyword identifiers.

Parameters

$value

Returns

string
Methods used from Yajra\Oci8\OracleReservedWords
isReserved()
Properties summary
protected string $wrapper

The keyword identifier wrapper format.

The keyword identifier wrapper format.

# '%s'
protected string $schema_prefix
# ''
Properties used from Yajra\Oci8\OracleReservedWords
$reserves
API documentation generated by ApiGen