Tag Archives: Oracle

FreeRADIUS with Oracle

By | Published: July 7, 2008
I recently needed to find a RADIUS server for use in a project where I could stick profile data into Oracle. I remembered seeing FreeRADIUS a while back so I checked to see if it was active and supported Oracle. Sure enough it did. It was a little tricky to set up because some of [...]
Posted in system administration | Also tagged , | 2 Comments

Using Oracle Instant Client and SQLPlus

By | Published: January 19, 2007
Some time ago Oracle introduced their Instant Client as an alternative to needing a full install of the Oracle client to run your own apps or SQLPlus. I've been putting the Instant Client to good use these days and figured I would give a quick howto on getting it set up.
Posted in system administration | Also tagged | 6 Comments

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

Converting unix or java timestamps (time since the epoch) to real dates with Oracle

By | Published: April 29, 2006
A few days ago I made use of a couple Oracle built in functions and it made me happy I didn't have to write a stored proc or some type of mini-app to do it. I needed to parse a timestamp out of a field that was put there by a java program. The timestamp [...]
Posted in database administration | Tagged | Leave a comment

Ruby Oracle DBI ActiveRecord in 7 steps

By | Published: March 23, 2006
Setting up ruby to work with Oracle seems to be a pain for a lot of people. Here are the steps I follow to set it up on a linux box from nothing to Active Record or DBI in 7 steps.
Posted in programming | Also tagged , , | Leave a comment

Fun with Oracle Strings

By | Published: February 14, 2006
Today I needed to find a way to count the number of unique email domains in a table. I figured there was a way of getting the index of a string in another string and sure enough there is. This did the trick in Oracle: The INSTR function gives you the location in a string [...]
Posted in database administration | Tagged | Leave a comment