SQL: DROP, CREATE,… How to avoid errors?

In SQL we often want to create or drop an object (TABLE, VIEW, SEQUENCE, INDEX, SYNONYM, DATABASE, USER, SCHEMA,….) Now we do not know if this thing exists or not. We would like to write scripts, that work in either case. So something like CREATE TABLE IF NOT EXISTS XYZ (…); or DROP TABLE IF …

Share Button

How to create ISO Date String

It is a more and more common task that we need to have a date or maybe date with time as String. There are two reasonable ways to do this: * We may want the date formatted in the users Locale, whatever that is. * We want to use a generic date format, that is …

Share Button

Oracle Bug with empty strings

Deutsch Oracle databases seem to consider empty strings and null the same. This contradicts the SQL specification and is therefore a bug. Unfortunately, it would be almost impossible for Oracle to fix this, because too many applications using Oracle for decades rely on this behavior. It is therefore crucial to know about this bug when …

Share Button