class_docstr: Interact with Oracle SQL.
  
  :param oracle_conn_id: The :ref:`Oracle connection id <howto/connection:oracle>`
      used for Oracle credentials.
  :param thick_mode: Specify whether to use python-oracledb in thick mode. Defaults to False.
      If set to True, you must have the Oracle Client libraries installed.
      See `oracledb docs<https://python-oracledb.readthedocs.io/en/latest/user_guide/initialization.html>`
      for more info.
  :param thick_mode_lib_dir: Path to use to find the Oracle Client libraries when using thick mode.
      If not specified, defaults to the standard way of locating the Oracle Client library on the OS.
      See `oracledb docs
      <https://python-oracledb.readthedocs.io/en/latest/user_guide/initialization.html#setting-the-oracle-client-library-directory>`
      for more info.
  :param thick_mode_config_dir: Path to use to find the Oracle Client library
      configuration files when using thick mode.
      If not specified, defaults to the standard way of locating the Oracle Client
      library configuration files on the OS.
      See `oracledb docs
      <https://python-oracledb.readthedocs.io/en/latest/user_guide/initialization.html#optional-oracle-net-configuration-files>`
      for more info.
  :param fetch_decimals: Specify whether numbers should be fetched as ``decimal.Decimal`` values.
      See `defaults.fetch_decimals
      <https://python-oracledb.readthedocs.io/en/latest/api_manual/defaults.html#defaults.fetch_decimals>`
      for more info.
  :param fetch_lobs: Specify whether to fetch strings/bytes for CLOBs or BLOBs instead of locators.
      See `defaults.fetch_lobs
      <https://python-oracledb.readthedocs.io/en/latest/api_manual/defaults.html#defaults.fetch_decimals>`
      for more info.
class_docstr_tok: ["Interact","with","Oracle","SQL",".",":","param","oracle_conn_id",":","The",":","ref",":","`","Oracle","connection","id","<","howto\/connection",":","oracle",">","`","used","for","Oracle","credentials",".",":","param","thick_mode",":","Specify","whether","to","use","python-oracledb","in","thick","mode",".","Defaults","to","False",".","If","set","to","True",",","you","must","have","the","Oracle","Client","libraries","installed",".","See","`","oracledb","docs","<","https",":","\/\/python-oracledb.readthedocs.io\/en\/latest\/user_guide\/initialization.html",">","`","for","more","info",".",":","param","thick_mode_lib_dir",":","Path","to","use","to","find","the","Oracle","Client","libraries","when","using","thick","mode",".","If","not","specified",",","defaults","to","the","standard","way","of","locating","the","Oracle","Client","library","on","the","OS",".","See","`","oracledb","docs","<","https",":","\/\/python-oracledb.readthedocs.io\/en\/latest\/user_guide\/initialization.html","#","setting-the-oracle-client-library-directory",">","`","for","more","info",".",":","param","thick_mode_config_dir",":","Path","to","use","to","find","the","Oracle","Client","library","configuration","files","when","using","thick","mode",".","If","not","specified",",","defaults","to","the","standard","way","of","locating","the","Oracle","Client","library","configuration","files","on","the","OS",".","See","`","oracledb","docs","<","https",":","\/\/python-oracledb.readthedocs.io\/en\/latest\/user_guide\/initialization.html","#","optional-oracle-net-configuration-files",">","`","for","more","info",".",":","param","fetch_decimals",":","Specify","whether","numbers","should","be","fetched","as","``","decimal.Decimal","``","values",".","See","`","defaults.fetch_decimals","<","https",":","\/\/python-oracledb.readthedocs.io\/en\/latest\/api_manual\/defaults.html","#","defaults.fetch_decimals",">","`","for","more","info",".",":","param","fetch_lobs",":","Specify","whether","to","fetch","strings\/bytes","for","CLOBs","or","BLOBs","instead","of","locators",".","See","`","defaults.fetch_lobs","<","https",":","\/\/python-oracledb.readthedocs.io\/en\/latest\/api_manual\/defaults.html","#","defaults.fetch_decimals",">","`","for","more","info","."]
code: def __init__(
      self,
      *args,
      thick_mode: bool | None = None,
      thick_mode_lib_dir: str | None = None,
      thick_mode_config_dir: str | None = None,
      fetch_decimals: bool | None = None,
      fetch_lobs: bool | None = None,
      **kwargs,
  ) -> None:
      super().__init__(*args, **kwargs)
  
      self.thick_mode = thick_mode
      self.thick_mode_lib_dir = thick_mode_lib_dir
      self.thick_mode_config_dir = thick_mode_config_dir
      self.fetch_decimals = fetch_decimals
      self.fetch_lobs = fetch_lobs
  
file_path: airflow/airflow/providers/oracle/hooks/oracle.py
imports: from __future__ import annotations
  import math
  import warnings
  from datetime import datetime
  import oracledb
  from airflow.exceptions import AirflowProviderDeprecationWarning
  from airflow.providers.common.sql.hooks.sql import DbApiHook
label_desc: Use image node_id 1 to create a new OracleHook object from inherited base classes: DbApiHook with example: obj = OracleHook()