Interested to Buy Any Domain ? << Click Here >> for more details...
PLS-00399: different types of columns in UNION, INTERSECT,
or MINUS expression
- 1 Answers
- 3540 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-07572: szrfc: insufficient rolename buffer space
ORA-03215: File Size specified for resize is too small
ORA-23340: incorrect resolution method string
NCR-03012: NCRO: Invalid session mode
QSM-02125: subquery join conditions don't meet requirements for capability
ORA-14313: Value string does not exist in partition string
ORA-06955: Number of database servers exceed limit
ORA-00406: COMPATIBLE parameter needs to be string or greater
ORA-13150: failed to insert exception record
ORA-38601: FI Not enough memory for frequent itemset counting: string
ORA-01627: rollback segment number 'string' is not online
TNS-01014: set|show log_{ } [<value>]: set|show log parameters of current listener
Oracle Errors 
