IT Sky Consulting GmbH
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 …
„SQL: DROP, CREATE,… How to avoid errors?“ weiterlesen
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 …
„How to create ISO Date String“ weiterlesen
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 …
„Oracle Bug with empty strings“ weiterlesen