User Input: Identify the object, such as a specific PL/SQL procedure or function.įramework Activities: Select the object for processing. The steps are as follows, including the user input for before the step is run and the framework activities for the step while the test is being run. The SQL Developer unit testing framework involves a set of sequential steps for each test case. Using Variable Substitution in Validation ActionsĮxporting and Importing Unit Test Objects

Using Lookups to Simplify Unit Test Creation Using a Dynamic Value Query to Create a Unit Test SQL Developer User Interface for Unit Testing This topic contains the following topics: The unit testing feature is part of the support within the SQL Developer family of products for major parts of the life cycle of database system development, from design (provided by Data Modeler) to development to testing. The SQL Developer implementation of unit testing is modeled on the classic and well known xUnit collection of unit test frameworks. You create tests, and for each you provide information about what is to be tested and what result is expected. The SQL Developer unit testing feature provides a framework for testing PL/SQL objects, such as functions and procedures, and monitoring the results of such objects over time. Is an open source testing framework for PL/SQL. Oracle recommends using the SQL Developer extension for utPLSQL, which

This functionality is deprecated in SQL Developer Release 20.4.

Oracle sql developer alternatives