Oracle

Type: Relational Database Management System (RDBMS)

Description: A powerful, commercial RDBMS known for its performance, reliability, and comprehensive features. It supports SQL and offers features like partitioning, clustering, and advanced security.

How to send the query

Description

<oracle> – command which is responsible for sending the queries to Oracle DB in testing scenarios

Required parameters:

  1. comment

  2. alias - unique name of the DB you configured in your integration.xml file

  3. file - specifies the expected file name

  4. query - contains the Oracle DB query

Optional parameters :

  1. condition - condition according to which this test step will or won't be executed

  2. threshold - parameter, where the maximum execution time of the command is defined (milliseconds), if the execution time is exceeded, the step will be defined as failed

<oracle comment="Get all user's from system" alias="ALIAS" file="expected_1.json"> <query>SELECT * FROM t_user</query> </oracle>