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

Class: ezcQueryExpressionOracle

The ezcQueryExpressionPgsql class is used to create SQL expression for PostgreSQL. [source]

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

Redefinition of

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

concat

Parameters

Name	Type	Description
0	string|array(string)	strings that will be concatinated.

Throws

Class	Description
ezcQueryVariableException	if no parameters are provided

Redefinition of

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