Oracle DB Development

by Mathias

This is a short update to the presumed bug I wrote about recently in this post. After a few back

Posted in Bug, SQL

by Mathias

If you live your life in an editor writing code or configuration files, you need Visual Code in your life.

Posted in Visual Code

by Mathias

Sometimes the results of a SQL is not at all what you expected. Most of the time it is a

Posted in Bug, SQL

by Mathias

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

by Mathias

This is essentially a not for myself for the next time I forget. It seems to be like once every

Posted in DBA, Performance

by Mathias

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

by Mathias

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

Screen Shot 2019-05-19 at 21.51.21
by Mathias

Have you been plagued with the issue of getting values like t1001 show up in columns you marked as primary key

Posted in APEX

by Mathias

I’ve seen this in a few places lately. When I ask the database gays there about it, they think this

Posted in Uncategorized

by Mathias

Views are great. They simplify design, makes code look more elegant and hides complexity. They also enables reuse by putting

Posted in Oracle, Performance