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

O2I-00115: Error opening the HFILE file

1 Answers  


DRG-11440: operation not supported for the string language

1 Answers  


CLSR-00512: Invalid CAA trigger event type [string]

1 Answers  


TNS-12661: Protocol authentication to be used

1 Answers  


KUP-04000: error initializing IO state for file string in string

1 Answers  






ORA-32816: foreign queue string is referenced by a subscriber or schedule

1 Answers  


ORA-07500: scglaa: $cantim unexpected return

1 Answers  


NID-00603: No datafiles found in database

1 Answers  


ORA-31468: cannot process DDL change record

1 Answers  


ORA-13025: polygon does not close

1 Answers  


ORA-13361: not enough sub-elements within a compound ETYPE

1 Answers  


ORA-00069: cannot acquire lock -- table locks disabled for string

1 Answers  


Categories