Tag Archives: sql

How to get the next date for a weekday using Oracle

By | Published: August 2, 2006
If you ever need to find the next weekday from a given date in Oracle it turns out they have a built in function for doing just that. If you want the next Sunday from yesterday you would do: Valid entries for the day are: SUN, MON, TUE, WED, THU, FRI, and SAT Tags: Oracle, [...]
Posted in database administration | Also tagged | 2 Comments

SQL Beautifier

By | Published: July 6, 2006
I pulled a large amount of SQL out of some existing code and wanted to have it formated nicely for me. I figured there had to be some type of pretty printer for SQL available outside of applications like TOAD. I have access to TOAD but it would have required a reboot so I figured [...]
Posted in database administration | Also tagged | 3 Comments