* [[topbar |Table of Contents]] * [[intro:overview:what|Introduction]] * [[install:home|Installation]] * [[install:editions|Product Editions]] * [[install:requirements|System Requirements]] * [[install:platforms|Supported Platforms]] * [[install:guides:home|Installation Guides]] * [[install:licensing:home|Licensing]] * [[install:releases:home|Release Notes]] * [[admin:home|Administration]] * [[admin:admin:home|Administration Basics]] * [[admin:admin:architecture:home|Omnidex Architecture]] * [[admin:admin:applications:home|Building Applications]] * [[admin:basics:home|Omnidex Fundamentals]] * [[admin:basics:environments:home|Omnidex Environments]] * [[admin:basics:sqlengine:home|Omnidex SQL Engine]] * [[admin:basics:updates:home|Omnidex Updates]] * [[admin:basics:network:home|Network Services]] * [[admin:indexing:home|Omnidex Indexing]] * [[admin:indexing:concepts:home|Indexing Concepts]] * [[admin:indexing:indexes:home|Indexing Options]] * [[admin:indexing:creation:home|Index Creation]] * [[admin:indexing:strategies:home|Indexing Strategies]] * [[admin:indexing:activecounts:home|ActiveCounts]] * [[admin:indexing:powersearch:home|PowerSearch]] * [[admin:indexing:autocomplete:home|AutoComplete]] * [[admin:indexing:text:home|Omnidex Text]] * [[admin:features:home|Omnidex Features]] * [[admin:features:snapshots:home|Omnidex Snapshots]] * [[admin:features:grids:home|Omnidex Grids]] * [[admin:features:rollups:home|Rollup Tables]] * [[admin:features:geo:home|Geographic Searches]] * [[admin:features:expressioncols:home|Expression Columns]] * [[admin:features:segments:home|Omnidex Segments]] * [[admin:features:attach:home|Attaching Data]] * [[admin:features:export:home|Exporting Data]] * [[admin:optimization:home|Optimizing Queries]] * [[admin:optimization:plans:home|Query Plans]] * [[admin:optimization:caches:home|Dynamic Caches]] * [[admin:optimization:config:home|Configuring Omnidex]] * [[integration:home|Integration]] * [[integration:rdbms:home|Relational Databases]] * [[integration:rdbms:oracle:home|Oracle]] * [[integration:rdbms:sqlserver:home|SQL Server]] * [[integration:rdbms:mysql:home|MySQL]] * [[integration:rdbms:odbc:home|Generic ODBC]] * [[integration:rawdata:home|Raw Data Files]] * [[integration:rawdata:fixed:home|Fixed-length Files]] * [[integration:rawdata:delimited:home|Delimited Files]] * [[integration:rawdata:ost:home|Standalone Tables]] * [[dev:home|Development]] * [[dev:sql:home|Omnidex SQL]] * [[dev:sql:overview|Overview]] * [[dev:sql:statements:home|Statements]] * [[dev:sql:functions:home|Functions]] * [[dev:sql:examples:home|Examples]] * [[dev:connections:home|Connection Strings]] * [[dev:odbc:home|ODBC Interface]] * [[dev:jdbc:home|JDBC Interface]] * [[dev:debugging:home|Logging/Debugging]] * [[programs:home|Programs]] * [[programs:odxsql:home|OdxSQL]] * [[programs:odxnet:home|OdxNet]] * [[appendix:home|Appendix]] * [[dev:sql:home|Omnidex SQL]] * [[dev:sql:statements:home|Statements]] * [[dev:sql:functions:home|Functions]] * [[dev:sql:examples:home|Examples]] * [[http://www.omnidex.com/download/|Downloads]] * [[support:home|Support]]

~~NOTOC~~ {{page>:top_add&nofooter&noeditbtn}} ====== Integration: Relational Databases ====== ===== Oracle ===== [[integration:rdbms:oracle:home|Overview]] | [[integration:rdbms:oracle:environments|Environments]] | [[integration:rdbms:oracle:databases|Databases]] | [[integration:rdbms:oracle:tables|Tables]] | [[integration:rdbms:oracle:constraints|Constraints]] | [[integration:rdbms:oracle:datatypes|Datatypes]] | **[[integration:rdbms:oracle:queries|Queries]]** | [[integration:rdbms:oracle:updates|Updates]] | [[integration:rdbms:oracle:example|Example]] ---- ==== Queries ==== === === The Omnidex SQL Engine will optimize queries to take advantage of the Omnidex indexes. Many queries can be fulfilled entirely within the Omnidex indexes. This is especially true for queries that request counts or aggregations from one or more tables. Even queries that return columns of data can be completed using the Omnidex indexes, as long as all of the requested data resides in an index. Other queries will require access to the underlying Oracle data. The Omnidex SQL Engine will determine how to combine the results from the Omnidex indexes with the data from the Oracle database. Usually, this requires that Omnidex provide Oracle rowids or primary keys and request rows from the Oracle tables based on those values. Other times, Omnidex may issue a more complex statement to Oracle, asking it to perform a larger role in processing the query. In all cases, Omnidex will access the data in the Oracle database using standard Oracle SQL statements issued using the Oracle Call Interface (OCI). === Oracle-specific Syntax === Omnidex requires that all statements use Omnidex SQL syntax. Omnidex SQL uses ANSI SQL as a base, but also allows extensions from various databases, as well as Omnidex-specific extensions. If the statement, [[dev:sql:statements:set_sqlsyntax:home|SET SQL_SYNTAX ORACLE]] is issued, then Omnidex SQL will also support these Oracle-specific functions: * [[dev:sql:functions:chr|CHR]] * [[dev:sql:functions:instr|INSTR]] * [[dev:sql:functions:new_time|NEW_TIME]] * [[dev:sql:functions:nvl|NVL]] * [[dev:sql:functions:power|POWER]] * [[dev:sql:functions:substr|SUBSTR]] * [[dev:sql:functions:sysdate|SYSDATE]] * [[dev:sql:functions:systimestamp|SYSTIMESTAMP]] * [[dev:sql:functions:sys_extract_utc|SYS_EXTRACT_UTC]] * [[dev:sql:functions:to_date|TO_DATE]] * [[dev:sql:functions:to_number|TO_NUMBER]] Other Oracle-specific syntax will cause errors when submitted to Omnidex. In these situations, the statements must be converted to Omnidex SQL. ===== ===== **[[integration:rdbms:oracle:datatypes|Prev]]** | **[[integration:rdbms:oracle:updates|Next]]** ====== Additional Resources ====== See also: {{page>:integration:rdbms:see_also&nofooter&noeditbtn}} {{page>:bottom_add&nofooter&noeditbtn}}

 
Back to top
integration/rdbms/oracle/queries.txt ยท Last modified: 2016/06/28 22:38 (external edit)
 
 
chimeric.de = chi`s home Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0