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-38435: missing elementary attribute value or invalid name-value pairs

1 Answers  


ORA-32139: Cannot write to the stream

1 Answers  


ORA-07391: sftopn: fopen error, unable to open text file.

3 Answers  


QSM-01096: Materialized view with grouping sets contains duplicates

1 Answers  


ORA-01235: END BACKUP failed for string file(s) and succeeded for string

1 Answers  






ORA-28277: LDAP search, while authenticating global user with passwords, failed.

1 Answers  


ORA-01985: cannot create user as LICENSE_MAX_USERS parameter exceeded

1 Answers  


PCB-00233: Table size mismatch in INTO/USING. Minimum is: number

1 Answers  


IMP-00095: Resumable parameters ignored -- current session not resumable

1 Answers  


PCB-00005: Command line option MODE=ANSI required with option NLS_LOCAL=YES

1 Answers  


ORA-24154: rule string.string already in rule set string.string

1 Answers  


ORA-06954: Illegal file name

1 Answers  


Categories