Please help experts, how to generate reports in oracle.

onlysnake

For example, I want to query drug prices by month, quarter, and year.
And generate a drug price distribution chart within three years.

smallwarrior

No, help me

海蓝之谜

Did not fully understand the requirements of the landlord
1. Make a report in ORACLE Do you mean using only ORACCE database or you need to use other tools such as ORACLE ERP, crystal reports
2. As long as your data has a shape, such as dots, lines, etc.
The drug price distribution within 3.3 years does not meet your query conditions. Your query conditions must be entered in the year. If it is a cross-year, you need to use the query conditions from year to year.

the above:)

dragonfly_

oracle is just a database, not a reporting tool
Generate reports using specialized reporting tools

onlysnake

Well, just give an example:
  For example, if you want to use crystal reports to generate quarterly distribution charts within one year