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
Talking about Multi Tenant and applications, one has to talk about the different options for sharing. It is one of
Posted in DBA, Oracle
Are you using multi tenant with multiple containers and you’re not familiar with application containers? It allows you to set up
Posted in Uncategorized
Short answer: No This blog post is pretty much just to document what seems to have been hard to find
Posted in Uncategorized