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-00392: Type mismatch in arguments to BETWEEN

Answers were Sorted based on User's Feedback



PLS-00392: Type mismatch in arguments to BETWEEN..

Answer / guest

Cause: In a comparison such as X BETWEEN Y AND Z, the
expressions X, Y, and Z do not match in datatype, and it is
unclear which implicit conversion is required to correct the
mismatch.

Action: Change the expressions so that their datatypes
match. You might want to use datatype conversion functions.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

PLS-00392: Type mismatch in arguments to BETWEEN..

Answer / atul tandon

This error appears when any variable differs in data type
i.e suppose one is numeric and the others are character
and vice versa.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PCB-00500: No EXEC SQL CONTEXT USE statement encountered

1 Answers  


DRG-13305: 'off' attribute value must be in the range string..string, at line string

1 Answers  


PCC-02105: Unable to open list file

1 Answers  


DRG-50913: first document requested string is not a positive number

1 Answers  


QSM-00795: the SQL Tuning Set repository has not been implemented

1 Answers  


TNS-12689: Server Authentication required, but not supported

1 Answers  


ORA-15169: destination 'string' is a subdirectory of 'string'

1 Answers  


NNL-00800: Query requests received: number

1 Answers  


ORA-16056: backup control file archival requires proper syntax

1 Answers  


ORA-25306: Queue table string has buffered queues. Cannot alter

1 Answers  


ORA-04095: trigger 'string' already exists on another table, cannot replace it

1 Answers  


ORA-07655: slsprom:$TRNLOG failure

1 Answers  


Categories