ORA-30086: interval year-month result not allowed for
datetime subtraction
- 1 Answers
- 3496 Views
- I also Faced
- E-Mail Answers
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 |
DRG-10307: no servers running
PCC-02386: Use of the AT clause is not permitted here
ORA-19017: Attributes can only be simple scalars
ORA-02710: osnpop: fork failed
NNL-00804: Queries received, type META-DATA: number
ORA-38756: Flashback is already turned off for this tablespace.
ORA-12834: Instance group name, 'string', too long, must be less than string characters
NNL-00567: reorder_ns [<server_address>] : Generate the enhanced discovery file
ORA-13775: inconsistent datatype in input cursor
TNS-00275: Navigator: Tracing is now ON
PLS-01466: Null strings are not allowed
DRG-11115: a value for string must be specified
Oracle Errors 
