Assertions

Assertion types

Two
One for equality based matchers
One to check if expression evaluates to TRUE

Multiple assertions(matchers)
<,>,=,!=,inclusion,regexp,datatype(class),...

Assertion definition

Defined per datatype

Defined per operator

Assertions are used the same way

NO
Different usage depending on compared type

YES
All assertions follow common pattern

Assertion on User Defined Type data

NO

YES

Assertion on Collection Type data

YES (cumbersome and undocumented usage)

YES

Assertion on PL/SQL records data

YES (cumbersome and undocumented usage)

YES

Assertion on Cursor data

YES (complex usage)

YES

Assertion on complex structured data

NO

YES

Assertion on TIMESTAMP/CLOB/BLOB/RAW

NO

YES

Assertion on success (no exception)

NO

YES

Can tests table/view structure

NO

YES