Zeta Components - high quality PHP components

Zeta Components Manual :: Docs For Class ezcQueryExpressionOracle

Database::ezcQueryExpressionOracle

Class ezcQueryExpressionOracle

The ezcQueryExpressionOracle class is used to create SQL expression for Oracle.

This class reimplements the methods that have a different syntax in Oracle.

Source for this file: /Database/src/sqlabstraction/implementations/expression_oracle.php

ezcQueryExpression
   |
   --ezcQueryExpressionOracle

Version:

//autogentag//

Inherited Member Variables

From ezcQueryExpression
protected	`ezcQueryExpression::$db`
protected	`ezcQueryExpression::$intervalMap`
protected	`ezcQueryExpression::$quoteValues`

Method Summary

public ezcQueryExpressionOracle	`__construct( $db )` Constructs an empty ezcQueryExpression
public string	`bitAnd( $value1 , $value2 )` Returns the SQL that performs the bitwise AND on two values.
public string	`bitOr( $value1 , $value2 )` Returns the SQL that performs the bitwise OR on two values.
public string	`bitXor( $value1 , $value2 )` Returns the SQL that performs the bitwise XOR on two values.
public string	`concat( $... )` Returns a series of strings concatinated
public string	`dateAdd( $column , $expr , $type )` Returns the SQL that adds an interval to a timestamp value.
public string	`dateExtract( $column , $type )` Returns the SQL that extracts parts from a timestamp value.
public string	`dateSub( $column , $expr , $type )` Returns the SQL that subtracts an interval from a timestamp value.
public string	`in( $column )` Returns the SQL to check if a value is one in a set of given values.
public string	`now( )` Returns the current system date and time in the database internal format.
public string	`position( $substr , $value )` Returns the SQL to locate the position of the first occurrence of a substring
public string	`subString( $value , $from , [ $len = null] )` Returns part of a string.
public string	`unixTimestamp( $column )` Returns the SQL that converts a timestamp value to a unix timestamp.

Inherited Methods

From ezcQueryExpression
public ezcQueryExpression	`ezcQueryExpression::__construct()` Constructs an empty ezcQueryExpression
public string	`ezcQueryExpression::add()` Returns the SQL to add values or expressions together.
public string	`ezcQueryExpression::avg()` Returns the average value of a column
public string	`ezcQueryExpression::between()` Returns SQL that checks if an expression evaluates to a value between two values.
public string	`ezcQueryExpression::bitAnd()` Returns the SQL that performs the bitwise AND on two values.
public string	`ezcQueryExpression::bitOr()` Returns the SQL that performs the bitwise OR on two values.
public string	`ezcQueryExpression::bitXor()` Returns the SQL that performs the bitwise XOR on two values.
public string	`ezcQueryExpression::ceil()` Returns the SQL to calculate the next highest integer value from the number.
public void	`ezcQueryExpression::concat()` Returns a series of strings concatinated
public string	`ezcQueryExpression::count()` Returns the number of rows (without a NULL value) of a column
public string	`ezcQueryExpression::dateAdd()` Returns the SQL that adds an interval to a timestamp value.
public string	`ezcQueryExpression::dateExtract()` Returns the SQL that extracts parts from a timestamp value.
public string	`ezcQueryExpression::dateSub()` Returns the SQL that subtracts an interval from a timestamp value.
public string	`ezcQueryExpression::div()` Returns the SQL to divide values or expressions by eachother.
public string	`ezcQueryExpression::eq()` Returns the SQL to check if two values are equal.
public string	`ezcQueryExpression::floor()` Returns the SQL to calculate the next lowest integer value from the number.
protected string	`ezcQueryExpression::getIdentifier()` Returns the correct identifier for the alias $alias.
protected array(string)	`ezcQueryExpression::getIdentifiers()` Returns the correct identifiers for the aliases found in $aliases.
public string	`ezcQueryExpression::gt()` Returns the SQL to check if one value is greater than another value.
public string	`ezcQueryExpression::gte()` Returns the SQL to check if one value is greater than or equal to another value.
public bool	`ezcQueryExpression::hasAliases()` Returns true if this object has aliases.
public string	`ezcQueryExpression::in()` Returns the SQL to check if a value is one in a set of given values..
public string	`ezcQueryExpression::isNull()` Returns SQL that checks if a expression is null.
public string	`ezcQueryExpression::lAnd()` Returns the SQL to bind logical expressions together using a logical and.
public string	`ezcQueryExpression::length()` Returns the length of text field $column
public void	`ezcQueryExpression::like()` Match a partial string in a column.
public string	`ezcQueryExpression::lOr()` Returns the SQL to bind logical expressions together using a logical or.
public string	`ezcQueryExpression::lower()` Returns the SQL to change all characters to lowercase
public string	`ezcQueryExpression::lt()` Returns the SQL to check if one value is less than another value.
public string	`ezcQueryExpression::lte()` Returns the SQL to check if one value is less than or equal to another value.
public string	`ezcQueryExpression::max()` Returns the highest value of a column
public string	`ezcQueryExpression::md5()` Returns the md5 sum of $column.
public string	`ezcQueryExpression::min()` Returns the lowest value of a column
public string	`ezcQueryExpression::mod()` Returns the remainder of the division operation $expression1 / $expression2.
public string	`ezcQueryExpression::mul()` Returns the SQL to multiply values or expressions by eachother.
public string	`ezcQueryExpression::neq()` Returns the SQL to check if two values are unequal.
public string	`ezcQueryExpression::not()` Returns the SQL for a logical not, negating the $expression.
public string	`ezcQueryExpression::now()` Returns the current system date and time in the database internal format.
public string	`ezcQueryExpression::position()` Returns the SQL to locate the position of the first occurrence of a substring
public string	`ezcQueryExpression::round()` Rounds a numeric field to the number of decimals specified.
public string	`ezcQueryExpression::searchedCase()` Returns a searched CASE statement.
public void	`ezcQueryExpression::setAliases()` Sets the aliases $aliases for this object.
public void	`ezcQueryExpression::setValuesQuoting()` Sets the mode of quoting for parameters passed to SQL functions and operators.
public string	`ezcQueryExpression::sub()` Returns the SQL to subtract values or expressions from eachother.
public string	`ezcQueryExpression::subString()` Returns part of a string.
public string	`ezcQueryExpression::sum()` Returns the total sum of a column
public string	`ezcQueryExpression::unixTimestamp()` Returns the SQL that converts a timestamp value to a unix timestamp.
public string	`ezcQueryExpression::upper()` Returns the SQL to change all characters to uppercase

Methods

__construct

ezcQueryExpressionOracle __construct( $db )

Constructs an empty ezcQueryExpression

Parameters:

Name	Type	Description
`$db`	PDO

Redefinition of:

Method	Description
`ezcQueryExpression::__construct()`	Constructs an empty ezcQueryExpression

bitAnd

string bitAnd( string $value1 , string $value2 )

Returns the SQL that performs the bitwise AND on two values.

Parameters:

Name	Type	Description
`$value1`	string
`$value2`	string

Redefinition of:

Method	Description
`ezcQueryExpression::bitAnd()`	Returns the SQL that performs the bitwise AND on two values.

bitOr

string bitOr( string $value1 , string $value2 )

Returns the SQL that performs the bitwise OR on two values.

Parameters:

Name	Type	Description
`$value1`	string
`$value2`	string

Redefinition of:

Method	Description
`ezcQueryExpression::bitOr()`	Returns the SQL that performs the bitwise OR on two values.

bitXor

string bitXor( string $value1 , string $value2 )

Returns the SQL that performs the bitwise XOR on two values.

Parameters:

Name	Type	Description
`$value1`	string
`$value2`	string

Redefinition of:

Method	Description
`ezcQueryExpression::bitXor()`	Returns the SQL that performs the bitwise XOR on two values.

concat

string concat( string|array(string) $... )

Returns a series of strings concatinated

concat() accepts an arbitrary number of parameters. Each parameter must contain an expression or an array with expressions.

Parameters:

Name	Type	Description
`$...`	string\|array(string)	strings that will be concatinated.

Exceptions:

Type	Description
`ezcQueryVariableException`	if no parameters are provided

Redefinition of:

Method	Description
`ezcQueryExpression::concat()`	Returns a series of strings concatinated

dateAdd

string dateAdd( string $column , numeric $expr , string $type )

Returns the SQL that adds an interval to a timestamp value.

Parameters:

Name	Type	Description
`$column`	string
`$expr`	numeric
`$type`	string	one of SECOND, MINUTE, HOUR, DAY, MONTH, or YEAR

Redefinition of:

Method	Description
`ezcQueryExpression::dateAdd()`	Returns the SQL that adds an interval to a timestamp value.

dateExtract

string dateExtract( string $column , string $type )

Returns the SQL that extracts parts from a timestamp value.

Parameters:

Name	Type	Description
`$column`	string
`$type`	string	one of SECOND, MINUTE, HOUR, DAY, MONTH, or YEAR

Redefinition of:

Method	Description
`ezcQueryExpression::dateExtract()`	Returns the SQL that extracts parts from a timestamp value.

dateSub

string dateSub( string $column , numeric $expr , string $type )

Returns the SQL that subtracts an interval from a timestamp value.

Parameters:

Name	Type	Description
`$column`	string
`$expr`	numeric
`$type`	string	one of SECOND, MINUTE, HOUR, DAY, MONTH, or YEAR

Redefinition of:

Method	Description
`ezcQueryExpression::dateSub()`	Returns the SQL that subtracts an interval from a timestamp value.

in

string in( string|array(string) $column )

Returns the SQL to check if a value is one in a set of given values.

in() accepts an arbitrary number of parameters. The first parameter must always specify the value that should be matched against. Successive parameters must contain a logical expression or an array with logical expressions. These expressions will be matched against the first parameter.

Example:

$q->select( '*' )->from( 'table' )
->where( $q->expr->in( 'id', 1, 2, 3 ) );

Oracle limits the number of values in a single IN() to 1000. This implementation creates a list of combined IN() expressions to bypass this limitation.

Parameters:

Name	Type	Description
`$column`	string\|array(string)	values that will be matched against $column

Exceptions:

Type	Description
`ezcQueryInvalidParameterException`	if the 2nd parameter is an empty array.
`ezcQueryVariableParameterException`	if called with less than two parameters.

Redefinition of:

Method	Description
`ezcQueryExpression::in()`	Returns the SQL to check if a value is one in a set of given values..

now

string now( )

Returns the current system date and time in the database internal format.

Note: The returned timestamp is a SYSDATE. The format can be set after connecting with e.g.: ALTER SESSION SET NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS'

Redefinition of:

Method	Description
`ezcQueryExpression::now()`	Returns the current system date and time in the database internal format.

position

string position( string $substr , string $value )

Returns the SQL to locate the position of the first occurrence of a substring

Parameters:

Name	Type	Description
`$substr`	string
`$value`	string

Redefinition of:

Method	Description
`ezcQueryExpression::position()`	Returns the SQL to locate the position of the first occurrence of a substring

subString

string subString( string $value , int $from , [int $len = null] )

Returns part of a string.

Note: Not SQL92, but common functionality.

Parameters:

Name	Type	Description
`$value`	string	the target $value the string or the string column.
`$from`	int	extract from this characeter.
`$len`	int	extract this amount of characters.

Redefinition of:

Method	Description
`ezcQueryExpression::subString()`	Returns part of a string.

unixTimestamp

string unixTimestamp( string $column )

Returns the SQL that converts a timestamp value to a unix timestamp.

Parameters:

Name	Type	Description
`$column`	string

Redefinition of:

Method	Description
`ezcQueryExpression::unixTimestamp()`	Returns the SQL that converts a timestamp value to a unix timestamp.

Documentation generated by phpDocumentor 1.4.3