Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-00604: error occurred at recursive SQL level string

1 Answers  


ORA-22958: This operation is not allowed in check constraints or triggers

1 Answers  


ORA-30102: 'string' is not in the legal range for 'string'

1 Answers  


ORA-06135: NETTCP: connection rejected; server is stopping

1 Answers  


ORA-09813: Unable to get directory status

1 Answers  






ORA-25473: cannot store string in rule action context

1 Answers  


ORA-32584: missing LOG keyword

1 Answers  


ORA-32025: %s.string is not a table or view object.

1 Answers  


DRG-11832: Request Entity Too Large

1 Answers  


TNS-00110: Could not initialize network from file TNSNET.ORA

1 Answers  


ORA-07223: slspool: fork error, unable to spawn spool process.

1 Answers  


QSM-02034: no joins are present in the HAVING clause

1 Answers  






Categories