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

DRG-10827: open_con must be performed before count_last

1 Answers  


ORA-14177: STORE-IN (Tablespace list) can only be specified for a LOCAL index on a Hash or Composite Range Hash table

1 Answers  


ORA-28040: No matching authentication protocol

1 Answers  


RMAN-06205: Uncataloged string objects

1 Answers  


PCC-02320: arithmetic expression does not have correct operand types

1 Answers  


PCC-02365: Indicator array size cannot be smaller than host array size

1 Answers  


ORA-12566: TNS:protocol error

1 Answers  


SQL-02125: Connect error, can't get error text

1 Answers  


ORA-24507: invalid combination of character set ids

1 Answers  


ORA-01905: STORAGE keyword expected

1 Answers  


ORA-01128: cannot start online backup - file string is offline

1 Answers  


QSM-00785: the directive string is not supported for task string at this time

1 Answers  


Categories