PRADO Component Framework for PHP 5
  • Home
  • About
  • Testimonials
  • Demos
  • Download
  • Documentation
  • Forum
  • Development
  • Tutorials
  • Class Docs
  • API Manual
  • Wiki

Packages

  • None
  • System
    • Caching
    • Collections
    • Data
      • ActiveRecord
        • Relations
        • Scaffold
          • InputBuilder
      • Commom
        • Sqlite
      • Common
        • Mssql
        • Mysql
        • Oracle
        • Pgsql
        • Sqlite
      • DataGateway
      • SqlMap
        • Configuration
        • Statements
    • Exceptions
    • I18N
    • IO
    • Security
    • Util
    • Web
      • Javascripts
      • Services
      • UI
        • ActiveControls
        • WebControls
    • Xml
  • Wsat
    • pages
  • Overview
  • Package
  • Class
  • Tree
  • Deprecated
  • Todo

Class TOracleCommandBuilder

TOracleCommandBuilder provides specifics methods to create limit/offset query commands for Oracle database.

TComponent
Extended by TDbCommandBuilder
Extended by TOracleCommandBuilder
Package: System\Data\Common
Copyright: Copyright © 2005-2014 PradoSoft
License: http://www.pradosoft.com/license/
Author: Marcos Nobre <marconobre[at]gmail[dot]com>
Since: 3.1
Located at Data/Common/Oracle/TOracleCommandBuilder.php
Methods summary
public string
# getSearchExpression( array $fields, string $keywords )

Overrides parent implementation. Only column of type text or character (and its variants) accepts the LIKE criteria.

Overrides parent implementation. Only column of type text or character (and its variants) accepts the LIKE criteria.

Parameters

$fields
array
list of column id for potential search condition.
$keywords
string
string of keywords

Returns

string
SQL search condition matching on a set of columns.

Overrides

TDbCommandBuilder::getSearchExpression()
protected boolean
# isSearchableColumn( mixed $column )

Returns

boolean
true if column can be used for LIKE searching.
public string
# applyLimitOffset( string $sql, integer $limit = -1, integer $offset = -1 )

Overrides parent implementation to use Oracle way of get paginated RecordSet instead of using LIMIT sql clause.

Overrides parent implementation to use Oracle way of get paginated RecordSet instead of using LIMIT sql clause.

Parameters

$sql
string
SQL query string.
$limit
integer
maximum number of rows, -1 to ignore limit.
$offset
integer
row offset, -1 to ignore offset.

Returns

string
SQL with limit and offset in Oracle way.

Overrides

TDbCommandBuilder::applyLimitOffset()
Methods inherited from TDbCommandBuilder
__construct(), applyCriterias(), applyOrdering(), bindArrayValues(), bindColumnValues(), createCommand(), createCountCommand(), createDeleteCommand(), createFindCommand(), createInsertCommand(), createUpdateCommand(), getColumnBindings(), getDbConnection(), getInsertFieldBindings(), getLastInsertID(), getPdoType(), getSearchCondition(), getSelectFieldList(), getTableInfo(), hasIntegerKey(), setDbConnection(), setTableInfo()
Methods inherited from TComponent
__call(), __destruct(), __get(), __isset(), __set(), __sleep(), __unset(), __wakeup(), addParsedObject(), asa(), attachBehavior(), attachBehaviors(), attachClassBehavior(), attachEventHandler(), canGetProperty(), canSetProperty(), clearBehaviors(), createdOnTemplate(), detachBehavior(), detachBehaviors(), detachClassBehavior(), detachEventHandler(), disableBehavior(), disableBehaviors(), enableBehavior(), enableBehaviors(), evaluateExpression(), evaluateStatements(), fxAttachClassBehavior(), fxDetachClassBehavior(), getAutoGlobalListen(), getBehaviorsEnabled(), getClassHierarchy(), getEventHandlers(), getListeningToGlobalEvents(), getSubProperty(), hasEvent(), hasEventHandler(), hasProperty(), isa(), listen(), raiseEvent(), setSubProperty(), unlisten()
Constants inherited from TComponent
GLOBAL_RAISE_EVENT_LISTENER
Terms of Service | Contact Us
PRADO v3.2.4 API Manual API documentation generated by ApiGen 2.8.0
Copyright © 2006-2014 by the PRADO Group.
Powered by PRADO