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

ORA-12431: invalid audit action

1 Answers  


ORA-12409: policy startup failure for string policy

1 Answers  


QSM-00777: the specified directive string is unsupported at this time

1 Answers  


NNL-00242: Processing of modification requests is currently disabled

1 Answers  


ORA-25001: cannot create this trigger type on views

1 Answers  


ORA-36634: (XSDUNION02) INTEGER dimension workspace object cannot be used as a concat dimension base.

1 Answers  


DRG-50862: failed to create new Oracle object

1 Answers  


RMAN-08501: output filename=string recid=string stamp=string

1 Answers  


IMG-00804: Syntax error in attribute string

1 Answers  


ORA-16715: Log transport related property string of standby "string" is inconsistent.

1 Answers  


ORA-02470: TO_DATE, USERENV, or SYSDATE incorrectly used in hash expression.

1 Answers  


NCR-04012: NCRR: Invalid address descriptor

1 Answers  


Categories