Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query returning empty months

Javier PMar 10 2022

Hi all,

I have this query that returns the production of the last 12 months.
This is the query:

select
    null
  , sum(f.comision)         value
  , trunc(f.efectiva, 'MM') label
from
    risk_facturas f
where
    f.efectiva >= add_months(trunc(sysdate), -13) and f.efectiva < trunc(sysdate) + 1
and f.organizacion_id = :APP_GET_ORGANIZACION_ID
group by
    trunc(f.efectiva, 'MM')

How can I get a line for every month no matter if it has any production or is just 0? Can this be done?
Thanks for the help!
Javier
This post has been answered by Solomon Yakobson on Mar 12 2022
Jump to Answer

Comments

User_OOTEX

OracleExpressInstall.PNG
Will the TNS-04415: File i/o error cause the XE Database installation to hang indefinitely?
Oracle Net Services Configuration:
ProfileException: Could not save Profile: TNS-04415: File i/o error
ListenerException: Could not save listener: TNS-04415: File i/o error
ServiceAliasException: Could not save Service Alias: TNS-04415: File i/o error

Prior to my failed installation attempt the
System > System Properties > Advanced> System Variable
TNS_ADMIN
was already set to a directory that I do not have write access to.
\\AUP-USFFS02.forest.usf.edu\Azure$\IT-DM\oracle\network\admin
will this prevent the XE database from installing?
Do i need to temporarily un-set this system variable for XE to install?

User_OOTEX
Answer

un-setting the TNS_ADMIN system variable was not enough.
Manually removed the entire original failed oracle express installation by following rebellion rider's outstanding video tutorial http://www.rebellionrider.com/how-to-uninstall-oracle-database-18c-by-manish-sharma/
Delete the Environment Variable
Delete the Oracle Database 18c Windows registries
Restart Your System
Delete the Oracle Home User and Groups
Delete The Oracle Database 18c
Re-ran the Oracle Express setup.exe successfully this time. The XE database installed without further issue

Marked as Answer by User_OOTEX · Mar 10 2021
User_IRLFL

Someone has spent more than 4 hours waiting for installer finishes?
Additionally, How heavy is the installation folder? My folder is up to 15 GB and installation does not finish yet

1 - 3

Post Details

Added on Mar 10 2022
#sql-developer
18 comments
127 views