# tOracleInput

Reads an Oracle database and extracts fields based on a query.

tOracleInput executes a database query with a strictly defined order which must correspond to the schema definition. Then it passes on the field list to the next component via a Main row link.

For more technologies supported by Talend, see [Talend components](https://help.qlik.com/talend/r/en-US/7.3/components/oracle).

Depending on the Talend product you are using, this component can be used in one, some or all of the following Job frameworks:

* Standard: see [tOracleInput Standard properties](https://help.qlik.com/talend/en-US/components/7.3/oracle/toracleinput-standard-properties).

  The component in this framework is available in all Talend products.

* MapReduce: see [tOracleInput MapReduce properties (deprecated)](https://help.qlik.com/talend/en-US/components/7.3/oracle/toracleinput-mapreduce-properties-deprecated).

  The component in this framework is available in all Talend products with Big Data and Talend Data Fabric.

* Spark Batch: see [tOracleInput properties for Apache Spark Batch](https://help.qlik.com/talend/en-US/components/7.3/oracle/toracleinput-properties-for-apache-spark-batch).

  This component also allows you to connect and read data from a RDS Oracle database.

  The component in this framework is available in all Talend products with Big Data and Talend Data Fabric.

### In this section

* [tOracleInput Standard properties](https://help.qlik.com/talend/en-US/components/7.3/oracle/toracleinput-standard-properties)
* [tOracleInput MapReduce properties (deprecated)](https://help.qlik.com/talend/en-US/components/7.3/oracle/toracleinput-mapreduce-properties-deprecated)
* [tOracleInput properties for Apache Spark Batch](https://help.qlik.com/talend/en-US/components/7.3/oracle/toracleinput-properties-for-apache-spark-batch)

**Related concepts**

[Checking number format using a stored procedure](https://help.qlik.com/talend/en-US/components/7.3/oracle/toracleconnection-toracleinput-toraclesp-tlogrow-checking-number-format-using-stored-procedure-standard-component-the)

[Truncating and inserting file data into an Oracle database](https://help.qlik.com/talend/en-US/components/7.3/oracle/toracleinput-toraclebulkexec-tfileoutputdelimited-toraclebulkexec-tfileoutputdelimited-truncating-and-inserting-file-data-into-oracle-database-standard-component-this)

[Using context parameters when reading a table from an Oracle database](https://help.qlik.com/talend/en-US/components/7.3/oracle/toracleinput-tlogrow-using-context-parameters-when-reading-table-from-oracle-database-standard-component-in-this)