PLS-00399: different types of columns in UNION, INTERSECT,
or MINUS expression



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

Post New Answer

More Oracle Errors Interview Questions

NZE-29193: no CRL found using CRLDP mechanism

1 Answers  


IMP-00041: Warning: object created with compilation warnings

1 Answers  


ORA-13862: Statistics aggregation for client identifier string is not enabled

1 Answers  


RMAN-06426: RECOVERY_CATALOG_OWNER role must be granted to user string

1 Answers  


ORA-13641: Task cannot be interrupted yet. You may cancel it instead.

1 Answers  






RMAN-06583: at least 1 channel of TYPE DISK must be allocated to use AS COPY option

1 Answers  


NNC-00423: invalid data item syntax code string

1 Answers  


RMAN-06172: no autobackup found or specified handle is not a valid copy or piece

1 Answers  


ORA-12650: No common encryption or data integrity algorithm

1 Answers  


ORA-25226: dequeue failed, queue string.string is not enabled for dequeue

1 Answers  


KUP-04079: error fetching list of valid directories

1 Answers  


PLS-00540: object not supported in this context.

1 Answers  


Categories