Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

NZE-29040: There are no supported cipher suites.

1 Answers  


ORA-32308: object materialized views must use SELECT *

1 Answers  


ORA-07598: spwat: $SETIMR failure

1 Answers  


DRG-12803: invalid text datatype

1 Answers  


ORA-10614: Operation not allowed on this segment

1 Answers  


ORA-14014: maximum number of partitioning columns is 16

1 Answers  


DRG-10011: invalid object name string

1 Answers  


NZE-28777: binding creation failure

1 Answers  


ORA-06560: pos, string, is negative or larger than the buffer size, string

1 Answers  


ORA-22370: incorrect usage of method string

1 Answers  


TNS-04209: Trace Assistant Internal ERROR: Type Error

1 Answers  


ORA-13638: The user interrupted the current operation.

1 Answers  


Categories