This is a short update to the presumed bug I wrote about recently in this post. After a few back
Posted in Bug, SQL
If you live your life in an editor writing code or configuration files, you need Visual Code in your life.
Posted in Visual Code
Sometimes the results of a SQL is not at all what you expected. Most of the time it is a
Posted in Bug, SQL
Have you encountered LUHNs algorithm? I can almost guarantee it even if you’ve never heard the name before. It is
Posted in PL/SQL, SQL, Uncategorized
This is essentially a not for myself for the next time I forget. It seems to be like once every
Posted in DBA, Performance
It is time for aggregating data, using the GROUP BY keyword. Hint: I will be using the emp/dept tables used by Oracle
Posted in Back To Basics
Let’s start with baby steps We’re all very excited to read a new blog with a neat trick or a
Posted in Back To Basics
Have you been plagued with the issue of getting values like t1001 show up in columns you marked as primary key
Posted in APEX
I’ve seen this in a few places lately. When I ask the database gays there about it, they think this
Posted in Uncategorized
Views are great. They simplify design, makes code look more elegant and hides complexity. They also enables reuse by putting
Posted in Oracle, Performance