Interested to Buy Any Domain ? << Click Here >> for more details...
PLS-00399: different types of columns in UNION, INTERSECT,
or MINUS expression
- 1 Answers
- 3355 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 |
NZE-29026: Decryption failure
LPX-00664: VM Node-Stack overflow.
ORA-23608: invalid resolution column "string"
IMG-00518: invalid value for height or width
ORA-14133: ALTER TABLE MOVE cannot be combined with other operations
SQL-02124: NULL value returned by EXEC TOOLS statement
ORA-37060: (XSMCSESS08) number is not a valid custom member in dimension workspace object.
ORA-29356: These parameters can be specified only for directives that refer to consumer groups
ORA-30383: specified dimension level does not exist in the attribute
ORA-30431: refresh method must be ANY or INCREMENTAL or FORCE_FULL, not string
ORA-12472: policy string is being used
ORA-37104: (XSVPART04) A partitioned variable must be dimensioned by a single partition template only.
Oracle Errors 
