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-29836: failed to validate referenced operators

1 Answers  


EXP-00065: Error writing lob to the dump file.

1 Answers  


IMG-00805: SIGNATURE data has been corrupted or is invalid

1 Answers  


RMAN-06300: Report of files with less than number redundant backups

1 Answers  


ORA-32320: REFRESH FAST of "string"."string" unsupported after container table PMOPs

2 Answers  


ORA-12207: TNS:unable to perform navigation

1 Answers  


ORA-00117: PROTOCOL, ADDRESS or DESCRIPTION must be specified

1 Answers  


ORA-32583: query passed to table function has wrong number of elements in select list

1 Answers  


ORA-39317: illegal validation_check() call: only applys after clone/sync_code/valdation_check

1 Answers  


NNO-00268: warning: configuration database is not used, using checkpoint data instead

1 Answers  


PCC-00072: Input file name length exceeds the maximum length

1 Answers  


ORA-19910: can not change recovery target incarnation in controlfile

1 Answers  


Categories