Path

ez components / documentation / api reference / 1.1.2 / database

eZ Components 1.1.2

Database: ezcQueryExpressionOracle

[ Tutorial ] [ Class tree ] [ Element index ] [ ChangeLog ] [ Credits ]

Class: ezcQueryExpressionOracle

The ezcQueryExpressionPgsql class is used to create SQL expression for PostgreSQL. [source]
This class reimplements the methods that have a different syntax in postgreSQL.

Parents

ezcQueryExpression
   |
   --ezcQueryExpressionOracle

Method Summary

public ezcQueryExpressionOracle __construct( )
Constructs an empty ezcQueryExpression
public string concat( 0 )
Returns a series of strings concatinated

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 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::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.
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 a text field.
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::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 a field.
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.
public string ezcQueryExpression::now()
Returns the current system date.
public string ezcQueryExpression::round()
Rounds a numeric field to the number of decimals specified.
public void ezcQueryExpression::setAliases()
Sets the aliases $aliases for this object.
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

Methods

__construct

ezcQueryExpressionOracle __construct( )
Constructs an empty ezcQueryExpression

Redefinition of

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

concat

string concat( string|array(string) 0 )
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
0 string|array(string) strings that will be concatinated.

Throws

ClassDescription
ezcQueryVariableException if no parameters are provided

Redefinition of

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

Last updated: Thu, 01 Nov 2007