Bunch's Blog

One day I'll have a catchy subtitle, one day
posts - 87 , comments - 126 , trackbacks - 0

July 2012 Entries

Oracle and Looping Through Columns
I recently had to write a stored procedure that validated some data in a staging table. Looping through the records was pretty straight forward in Oracle using a loop (way easier than the SQL Server version). However there was set of columns in the table that were all the same type but different values that needed to be checked. To clarify I had a table setup like this: ID Name Number Position1 Position2 Position3 The ID is just an integer PK value, Name would be a players name, Number their jersey ......

Posted On Tuesday, July 17, 2012 3:24 PM | Comments (0) |

Powered by: