Update multiple columns

This is something I knew somewhere in the back of my head, but had forgotten about until now. When you want to update multiple columns in a single SQL statement based on a sub query you can of course duplicate this query for every column you want to update. But this violates the SPOD (Single […]

Read more

Write My Essay For Me Com

This write my essay for me com will allow you to recognize what technique you must decide to try tackle a marketplace that is more substantial. Third rate desires follow so forth, and second level ones. In regards to advertising his idea can be beneficial. While nearing a write my essay for me com person […]

Read more

Numeric sorting an alphanumeric column

The other day a customer came up to me and said: I have this column that holds numeric data, usually. But when I sort it it gets all messed up, because is sorts it alphanumerically. That is 10 is listed before 2 etc. My first suggestion was: well, sort by TO_NUMBER(column) then. Well, he replied, […]

Read more

Is it unique?

The other day one of my colleagues said something like: ‘Hey, this is strange. Oracle is not working correctly’. My first thought is then: ‘well, you probably didn’t specify you requirements correctly’. What was the problem? A unique index was created on a table to implement a business rule which can be rephrased into ‘One-Manager-Per-Department’. […]

Read more

Help With Essay

help with essay These qualified authors have all the necessary abilities and expertise to publish highquality content help with essay for dissertations or your documents. They have composed over 100 till now. Today days it is possible to find unique companies giving essay these companies staff experienced and trained authors, writing solutions. These authors offer […]

Read more

Some things to share…

I have been awfully quiet on my blog lately. I think that is because I have been busy with other things, like my garden and stuff like that. There are some ‘techie’ thing I have done in the meantime, though, I have submitted a couple of abstracts for Tech14. Hope at least one of them […]

Read more

PL/SQL vs SQL

There is a ‘rule’, I think it was created by Tom Kyte, stating: If you can do it in SQL, do it in SQL. I came across some code the other day that makes perfect sense to do then you are running an Oracle 10g (or earlier) instance. I rewrote the code to use only […]

Read more