In 126.96.36.199, I have this query:
SELECT metric_name FROM sysman.mgmt$metric_daily WHERE target_name = 'myfundb' AND target_type = 'oracle_database' AND rollup_timestamp > TRUNC(sysdate-7)
The above is tab-indented, as a subquery taken from a larger query for debugging. It runs with F5, but F9 produces:
ORA-00907: missing right parenthesis
If I remove the leading tab from the SELECT line or comment out the last “AND” line, F9 works fine.
Disclaimer: Please help me fight the injustice that is tabicide. For just pennies a day, you too can help discarded tabs find meaningful work with me and my organization, CHR9. Not a registered 501(c )(3) organization. Not registered anywhere, for that matter.