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...


ORA-30086: interval year-month result not allowed for
datetime subtraction



ORA-30086: interval year-month result not allowed for datetime subtraction..

Answer / guest

Cause: An attempt was made to specify interval year to month
as the result of datetime subtraction.

Action: This is not allowed currently due to unclear
specification in SQL Standards for this interval type.
Change the interval type to interval day to second and
resubmit statement.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

AUD-00806: first argument to SpeechContains must be a column

1 Answers  


ORA-24048: cannot create QUEUE_TABLE, user does not have access to AQ object types

1 Answers  


ORA-09311: slsleep: error temporarily suspending process

1 Answers  


ORA-07577: no such user in authorization file

1 Answers  


PLS-00227: subprogram 'in' formal string is not yet denotable

1 Answers  


ORA-06114: NETTCP: SID lookup failure

1 Answers  


ORA-20000: %s

1 Answers  


ORA-26010: Column string in table string is NOT NULL and is not being loaded

1 Answers  


ORA-23433: executing against wrong master site string

1 Answers  


ORA-19503: cannot obtain information on device, name="string", type="string", parms="string"

1 Answers  


ORA-27506: IPC error connecting to a port

1 Answers  


ORA-00091: LARGE_POOL_SIZE must be at least string

1 Answers  


Categories