Has anyone heard of Oracle limiting the number of rows oracle reports can import into an excel spreadsheet? I was reading on something online about it limiting to 65k rows and then there's a patch you can apply that will increase it to 1 million rows. How do I check if my database has these patches?
How to Create User-Defined Aggregates in Oracle
Before we begin creating these things, what are user-defined aggregates? They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface. I made a script to download the Alert Log, look for errors, and email me the trace files. In this article I'll describe what I did and share my script.