You are currently viewing the 0.10 branch api documentation. Switch to 1.0 or 1.1

0.10 Doctrine_Expression_Oracle

Doctrine Expression Oracle

Doctrine_Expression_Sqlite

Inheritence

Doctrine_Expression_Oracle  < Doctrine_Expression_Driver  < Doctrine_Connection_Module

Method Summary

Returns Name Description
string concat concat() accepts an arbitrary number of parameters. Each parameter must contain an expression
string guid
string now There are three special variables for current date and time:

  • CURRENT_TIMESTAMP (date and time, TIMESTAMP type)

  • CURRENT_DATE (date, DATE type)

  • CURRENT_TIME (time, TIME t
string random
string substring Note: Not SQL92, but common functionality.

Methods inherited from Doctrine_Expression_Driver

pi , upper , avg , md5 , add , between , length , ltrim , __call , trim , cos , regexp , not , mul , substring , rtrim , neq , in , mod , now , sum , isNull , sub , lte , sin , gte , count , getIdentifiers , guid , max , eq , getIdentifier , round , lt , gt , div , lower , isNotNull , soundex , concat , acos , locate , min

Method Details

  • $arg1, $arg2 ... $argN strings that will be concatinated.

    (string) concat($arg1,)

    Returns a series of strings concatinated

    concat() accepts an arbitrary number of parameters. Each parameter must contain an expression


  • (string) guid()

    Returns global unique identifier

    Doctrine_Expression_Oracle


  • (string) now($type = 'timestamp')

    Return string to call a variable with the current timestamp inside an SQL statement

    There are three special variables for current date and time:



    • CURRENT_TIMESTAMP (date and time, TIMESTAMP type)




    • CURRENT_DATE (date, DATE type)




    • CURRENT_TIME (time, TIME t

      Doctrine_Expression_Oracle


  • (string) random()

    Doctrine_Expression_Oracle


  • $value an sql string literal or column name/alias
    $position where to start the substring portion
    $length the substring portion length

    (string) substring($value, $position, $length = null)

    return string to call a function to get a substring inside an SQL statement

    Note: Not SQL92, but common functionality.

    Doctrine_Expression_Oracle