Explanation/Reference:
A: Format: SDO_CONTAINS(geometry1, geometry2);
Checks if any geometries in a table have the CONTAINS topological relationship with a specified geometry.
The expression SDO_CONTAINS(geometry1,geometry2) = 'TRUE' evaluates to TRUE for object pairs that have the CONTAINS topological relationship, and FALSE otherwise.
B: Format: SDO_INSIDE(geometry1, geometry2);
Checks if any geometries in a table have the INSIDE topological relationship with a specified geometry.
The expression SDO_INSIDE(geometry1,geometry2) = 'TRUE' evaluates to TRUE for object pairs that have the INSIDE topological relationship, and FALSE otherwise.
Note: Some topological relationships
CONTAINS: The interior and boundary of one object is completely contained in the interior of the other object.
INSIDE: The opposite of CONTAINS. A INSIDE B implies B CONTAINS A.
ANYINTERACT: The objects are non-disjoint.
DISJOINT: The boundaries and interiors do not intersect.
Figure of Topological Relationships

References:
https://docs.oracle.com/database/121/SPATL/spatial-relationships-and-filtering.htm#SPATL460
https://docs.oracle.com/database/121/SPATL/sdo_inside.htm#SPATL1029