Interested to Buy Any Domain ? << Click Here >> for more details...
PLS-00399: different types of columns in UNION, INTERSECT,
or MINUS expression
- 1 Answers
- 3465 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-16122: applying large dml transaction at SCN string
NID-00507: APPEND Append to output log NO
ORA-12350: database link being dropped is still mounted
ORA-12681: Login failed: the SecurID card does not have a pincode yet
DRG-10204: server update failed
DRG-11511: specified table does not contain a LONG RAW column
RMAN-06514: archived logs required to recover from this copy will not be kept
In VB program, I got message as " No Transaction is Active" , Backend database is Oracle, This message is coming some user's PC and Not all user's PC Please help me to resolve this issue
PLS-00666: Only index by binary_integer/pls_integer associative arrays allowed here
ORA-12031: cannot use primary key columns from materialized view log on "string"."string"
ORA-02035: illegal bundled operation combination
ORA-39082: Object type string created with compilation warnings
Oracle Errors 
