Interested to Buy Any Domain ? << Click Here >> for more details...
PLS-00399: different types of columns in UNION, INTERSECT,
or MINUS expression
- 1 Answers
- 3445 Views
- I also Faced
- E-Mail Answers
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 |
ORA-27016: skgfcls: sbtinfo returned error
ORA-38775: cannot disable flash recovery area - flashback database is enabled
ORA-09744: smsget: mmap returned an error.
ORA-07327: smpdal: attempt to destroy pga when it was not mapped.
PCB-00006: Userid only used when SQLCHECK=FULL, userid ignored.
QSM-02028: group by CUBE
ORA-32006: %s initialization parameter has been deprecated
ORA-29934: index specified for association is not a domain index
PLS-00572: improper constraint form used
ORA-29864: analyzing domain indexes marked LOADING/FAILED not supported
ORA-38433: index "string" could not be maintained due to "string"
ORA-09940: ORACLE password file header is corrupt
Oracle Errors 
