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

ORA-12433: create trigger failed, policy not applied

1 Answers  


ORA-30340: illegal dimension name

1 Answers  


ORA-25964: column type incompatible with join column type

1 Answers  


ORA-36208: (XSAGOP05N) In AGGMAP workspace object, you can only specify NAOPERATOR string with the PROPORTIONAL or EVEN operators, not string.

1 Answers  


ORA-01033: ORACLE initialization or shutdown in progress

2 Answers  






ORA-06928: CMX: wrong ORACLE_SID

1 Answers  


ORA-37001: You have one or more attached but unupdated analytic workspaces.

1 Answers  


ORA-01600: at most one "string" in clause "string" of string

1 Answers  


ORA-29349: tablespace 'string' already exists

1 Answers  


NID-00490: LOG being redirected to STDERR due to errors.

1 Answers  


IMG-00717: destination image format does not support process options

1 Answers  


DRG-11102: assigned lexer can not operate on string language setting

1 Answers  


Categories