BLOG|DATABASE MANAGEMENT

Listing Page

Quest Software hero - {archive_type} Listing Page
Allowing Only One NULL
Allowing Only One NULL

Allowing Only One NULL

While the SQL standard allows multiple NULLS in a unique column, and that is how Postgres behaves, some database systems (e.g. MS_SQL) allow only a single NULL in such cases. Users migrating from othe...

Postgres Keywords
Postgres Keywords

Postgres Keywords

You might be aware that the SQL standard reserves certain identifiers that cannot be used for naming user objects. Postgres follows that standard, with slight modifications. For example, you cannot cr...

Toad for Oracle Code Road Map
Toad for Oracle Code Road Map

Toad for Oracle Code Road Map

As an Oracle developer you are working with a lot of lines of code.  Some that you have written and some that you have inherited but are now responsible for. How do you document your work and deciphe...

PRECIS R package
PRECIS R package

PRECIS R package

If you use R then you are very familiar with the SUMMARY function. If you use R then you are very familiar with the name Hadley Wickham. He has produced some really cool packages for R. He has produc...