I am trying to create Unit tests using SQL Developer UT framework.
But when i am creating validation using User PL/SQL code option.
Then how can i check value returned by l_count in code snippet below:
-- Please raise an exception if the validation fails.
-- For example:
SELECT count(*) into l_count
match_num = 99836936
AND Stg_status_flag <> 'E';
IF l_count = 0
Also, can someone please refer me to few more demo examples (apart from oracle docs) to implement good test cases with SQL developer.