Oracle Database 12c New Features

ORA-19205: Attribute 'string' qualifies a non-scalar value in the select list

ORA-19205: Attribute 'string' qualifies a non-scalar value in the select list

Cause:

The attribute immediately follows a value of object or collection type in the select list or type definition.


Action:

Remove the '@' sign, or make the previous value a scalar.