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

UDI-00015: invalid context or job state for parameter, 'string'.

1 Answers  


ORA-19800: Unable to initialize Oracle Managed Destination

1 Answers  


KUP-03017: length specified for VARIABLE records must be greater than 0

1 Answers  


ORA-23366: integer value string is less than 1

1 Answers  


TNS-12609: TNS: Receive timeout occurred

1 Answers  


ORA-14152: invalid number of partitions specified in PARTITIONS clause

1 Answers  


ORA-30037: Cannot perform parallel DML after a prior DML on the object

1 Answers  


PLS-00399: different types of columns in UNION, INTERSECT, or MINUS expression

1 Answers  


PCB-00218: RENAMES clause not allowed for host variable "string"

1 Answers  


ORA-00327: log string of thread string, physical size string less than needed string

1 Answers  


ORA-25252: listen failed, the address string is a non-persistent queue

1 Answers  


ORA-24328: illegal attribute value

1 Answers  


Categories