# 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.

### In this section

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

**Related concepts**

* [Checking number format using a stored procedure](https://help.qlik.com/talend/en-US/components/8.0/oracle/toracleconnection-toracleinput-toraclesp-tlogrow-checking-number-format-using-stored-procedure-standard-component-the)
* [Populating an Oracle data warehouse](https://help.qlik.com/talend/en-US/components/8.0/oracle/toracleoutput-toracleinput-tmap-toracleinput-tmap-populating-oracle-data-warehouse-standard-component-enterprise "The following Java scenario creates a three-component Job that populates a data warehouse. A tOracleInput component reads your client data stored in the CLIENT table. A tMap component allows you to modify this data and the modifications are transmitted to the Leadfact table in the database through a tOracleOutput component.")
* [Truncating and inserting file data into an Oracle database](https://help.qlik.com/talend/en-US/components/8.0/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/8.0/oracle/toracleinput-tlogrow-using-context-parameters-when-reading-table-from-oracle-database-standard-component-in-this)

**Related tasks**

* [Using Oracle as a vector database](https://help.qlik.com/talend/en-US/components/8.0/oracle/toracleconnection-toracleinput-toracleoutput-toracleclose-tfileinputdelimited-tmap-tlogrow-using-oracle-as-vector-db-standard-component)