PLS-00399: different types of columns in UNION, INTERSECT,
or MINUS expression
Answer / guest
Cause: The select lists to the left and right of a UNION,
INTERSECT, or MINUS expression select at least one column
that is mismatched in datatype. For example, the following
statement is faulty because the constant 3 has datatype
NUMBER, whereas SYSDATE has datatype DATE: CURSOR my_cur IS
SELECT 3 FROM emp INTERSECT SELECT SYSDATE FROM emp;
Action: Change the select lists so that they match in
datatype. You might want to use datatype conversion
functions in the select list of one or more queries.
Please add more information about this Error
Is This Answer Correct ? | 0 Yes | 0 No |
NZE-29193: no CRL found using CRLDP mechanism
IMP-00041: Warning: object created with compilation warnings
ORA-13862: Statistics aggregation for client identifier string is not enabled
RMAN-06426: RECOVERY_CATALOG_OWNER role must be granted to user string
ORA-13641: Task cannot be interrupted yet. You may cancel it instead.
RMAN-06583: at least 1 channel of TYPE DISK must be allocated to use AS COPY option
NNC-00423: invalid data item syntax code string
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece
ORA-12650: No common encryption or data integrity algorithm
ORA-25226: dequeue failed, queue string.string is not enabled for dequeue
KUP-04079: error fetching list of valid directories
PLS-00540: object not supported in this context.