Other News

Community

Transpose Rows to Columns

(Asif Momen) In the old Oracle 8i days, transposing rows to columns was not straight forward. As Oracle Developer (working on Oracle Developer 2000), I remember writing a query using MAX and DECODE functions to transpose rows into columns for my previous employer.

Community

XOR in SQL

(Patch) If you have ever tried to implement a requirement that implies that either one field is filled, or the other one but not both and not both not then you might have thought about using an XOR function. Unfortunately this is not implemented in Oracle SQL.

Editorials

Javascript With Multiple Browsers in Mind

Check out the latest SQL Server show – Watson! You may have seen him on Jeopardy! – Stephen Baker joins us on the show today talking about what was learned with the project. Stephen Baker wrote the book (literally) on the Watson project and all that it entailed – do not miss this show…[Watch the Show] Javascript With Multiple Browsers […]

Uncategorized

MS New Browser – IE9

SelecTViews – THE SQL Server Video Show with Stephen Wynkoop Watson! You may have seen him on Jeopardy! – Stephen Baker joins us on the show today talking about what was learned with the project. Stephen Baker wrote the book (literally) on the Watson project and all that it entailed – do not miss this show… [Watch the Show] MS […]