\JDatabaseQueryOracle

Oracle Query Building Class.

Synopsis

class JDatabaseQueryOracle extends JDatabaseQueryPdo implements JDatabaseQueryPreparable,JDatabaseQueryLimitable {

• // members
• protected  $offset;
• protected  $limit;
• protected  $bounded;
• // Inherited members from JDatabaseQuery
• protected JDatabaseDriver  $db;
• protected  $sql;
• protected  $type;
• protected JDatabaseQueryElement  $element;
• protected JDatabaseQueryElement  $select;
• protected JDatabaseQueryElement  $delete;
• protected JDatabaseQueryElement  $update;
• protected JDatabaseQueryElement  $insert;
• protected JDatabaseQueryElement  $from;
• protected JDatabaseQueryElement  $join;
• protected JDatabaseQueryElement  $set;
• protected JDatabaseQueryElement  $where;
• protected JDatabaseQueryElement  $group;
• protected JDatabaseQueryElement  $having;
• protected JDatabaseQueryElement  $columns;
• protected JDatabaseQueryElement  $values;
• protected JDatabaseQueryElement  $order;
• protected   $autoIncrementField;
• protected JDatabaseQueryElement  $call;
• protected JDatabaseQueryElement  $exec;
• protected JDatabaseQueryElement  $union;
• protected JDatabaseQueryElement  $unionAll;
• // methods
• public JDatabaseQueryOracle bind()
• public mixed getBounded()
• public JDatabaseQueryOracle clear()
• public string processLimit()
• public JDatabaseQueryOracle setLimit()
• // Inherited methods from JDatabaseQuery
• public string __call()
• public void __construct()
• public string __toString()
• public mixed __get()
• public JDatabaseQuery call()
• public string castAsChar()
• public string charLength()
• public JDatabaseQuery clear()
• public JDatabaseQuery columns()
• public string concatenate()
• public string currentTimestamp()
• public string dateFormat()
• public string dump()
• public JDatabaseQuery delete()
• public string escape()
• public JDatabaseQuery exec()
• public JDatabaseQuery from()
• public string year()
• public string month()
• public string day()
• public string hour()
• public string minute()
• public string second()
• public JDatabaseQuery group()
• public JDatabaseQuery having()
• public JDatabaseQuery innerJoin()
• public JDatabaseQuery insert()
• public JDatabaseQuery join()
• public JDatabaseQuery leftJoin()
• public int length()
• public string nullDate()
• public JDatabaseQuery order()
• public JDatabaseQuery outerJoin()
• public string quote()
• public mixed quoteName()
• public JDatabaseQuery rightJoin()
• public JDatabaseQuery select()
• public JDatabaseQuery set()
• public JDatabaseQuery setQuery()
• public JDatabaseQuery update()
• public JDatabaseQuery values()
• public JDatabaseQuery where()
• public void __clone()
• public mixed union()
• public mixed unionDistinct()
• public string format()
• public string dateAdd()
• public mixed unionAll()
}


Hierarchy

Extends

• JDatabaseQueryPdo

Implements

• JDatabaseQueryPreparable
• JDatabaseQueryLimitable

Members

protected

• $autoIncrementField —
• $bounded — array
• $call — JDatabaseQueryElement
• $columns — JDatabaseQueryElement
• $db — JDatabaseDriver
• $delete — JDatabaseQueryElement
• $element — JDatabaseQueryElement
• $exec — JDatabaseQueryElement
• $from — JDatabaseQueryElement
• $group — JDatabaseQueryElement
• $having — JDatabaseQueryElement
• $insert — JDatabaseQueryElement
• $join — JDatabaseQueryElement
• $limit — integer
• $offset — integer
• $order — JDatabaseQueryElement
• $select — JDatabaseQueryElement
• $set — JDatabaseQueryElement
• $sql — string
• $type — string
• $union — JDatabaseQueryElement
• $unionAll — JDatabaseQueryElement
• $update — JDatabaseQueryElement
• $values — JDatabaseQueryElement
• $where — JDatabaseQueryElement

Methods

public

• bind() — Method to add a variable to an internal array that will be bound to a prepared SQL statement before query execution. Also removes a variable that has been bounded from the internal bounded array when the passed in value is null.
• clear() — Clear data from the query or a specific clause of the query.
• getBounded() — Retrieves the bound parameters array when key is null and returns it by reference. If a key is provided then that item is returned.
• processLimit() — Method to modify a query already in string format with the needed additions to make the query limited to a particular number of results, or start at a particular offset. This method is used automatically by the __toString() method if it detects that the query implements the JDatabaseQueryLimitable interface.
• setLimit() — Sets the offset and limit for the result set, if the database driver supports it.

Inherited from JDatabaseQuery

public

• __call() — Magic method to provide method alias support for quote() and quoteName().
• __clone() — Method to provide deep copy support to nested objects and arrays when cloning.
• __get() — Magic function to get protected variable value
• __toString() — Magic function to convert the query to a string.
• call() — Add a single column, or array of columns to the CALL clause of the query.
• castAsChar() — Casts a value to a char.
• charLength() — Gets the number of characters in a string.
• clear() — Clear data from the query or a specific clause of the query.
• columns() — Adds a column, or array of column names that would be used for an INSERT INTO statement.
• concatenate() — Concatenates an array of column names or values.
• currentTimestamp() — Gets the current date and time.
• dateAdd() — Add to the current date and time.
• dateFormat() — Returns a PHP date() function compliant date format for the database driver.
• day() — Used to get a string to extract day from date column.
• delete() — Add a table name to the DELETE clause of the query.
• dump() — Creates a formatted dump of the query for debugging purposes.
• escape() — Method to escape a string for usage in an SQL statement.
• exec() — Add a single column, or array of columns to the EXEC clause of the query.
• format() — Find and replace sprintf-like tokens in a format string.
• from() — Add a table to the FROM clause of the query.
• group() — Add a grouping column to the GROUP clause of the query.
• having() — A conditions to the HAVING clause of the query.
• hour() — Used to get a string to extract hour from date column.
• innerJoin() — Add an INNER JOIN clause to the query.
• insert() — Add a table name to the INSERT clause of the query.
• join() — Add a JOIN clause to the query.
• leftJoin() — Add a LEFT JOIN clause to the query.
• length() — Get the length of a string in bytes.
• minute() — Used to get a string to extract minute from date column.
• month() — Used to get a string to extract month from date column.
• nullDate() — Get the null or zero representation of a timestamp for the database driver.
• order() — Add a ordering column to the ORDER clause of the query.
• outerJoin() — Add an OUTER JOIN clause to the query.
• quote() — Method to quote and optionally escape a string to database requirements for insertion into the database.
• quoteName() — Wrap an SQL statement identifier name such as column, table or database names in quotes to prevent injection risks and reserved word conflicts.
• rightJoin() — Add a RIGHT JOIN clause to the query.
• second() — Used to get a string to extract seconds from date column.
• select() — Add a single column, or array of columns to the SELECT clause of the query.
• set() — Add a single condition string, or an array of strings to the SET clause of the query.
• setQuery() — Allows a direct query to be provided to the database driver's setQuery() method, but still allow queries to have bounded variables.
• union() — Add a query to UNION with the current query.
• unionAll() — Add a query to UNION ALL with the current query.
• unionDistinct() — Add a query to UNION DISTINCT with the current query. Simply a proxy to Union with the Distinct clause.
• update() — Add a table name to the UPDATE clause of the query.
• values() — Adds a tuple, or array of tuples that would be used as values for an INSERT INTO statement.
• where() — Add a single condition, or an array of conditions to the WHERE clause of the query.
• year() — Used to get a string to extract year from date column.