Listing Page

• Toad

Fixing the “not a valid month” Oracle database error

Fixing the “not a valid month” Oracle database error

By  Deepak Vohra | March 2, 2022

If you use the DATEdata type in your SQL code, it is likely that you have come across the “not a valid month” Oracle database error. As we shall discuss, the error can be fixed with a slight tweak of ...

Read →

• Toad

SQL query optimization: Level up your SQL performance tuning

SQL query optimization: Level up your SQL performance tuning

By  Dan Hotka | April 27, 2021

Can’t find time for SQL performance tuning? Reliant on overstretched DBAs who don’t have a spare minute? Don’t let your queries slow down the database. Learn how to optimize SQL query — in minutes. ...

Read →