We are pleased to announce the release of Toad for DB2 v6.3. This new version is now available for customers to download here. Toad for DB2 is a comprehensive solution to improve DBA and development ...
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...
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...
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...
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...
In the previous parts of this article series, we started to look at Amazon AWS and its Relational Database Service (Amazon RDS). This included Amazon’s own Aurora database with MySQL compatibility and...
In this article series, we are looking at the steps for setting up the Oracle Hybrid Cloud via the latest version – Enterprise Manager Cloud Control 13c. We will follow the pre-steps, and then install...
In our article series, we are exploring the capabilities of Oracle Enterprise Manager Cloud Control 13c for the private Database as a Service (DBaaS) Cloud – including the setup of such a cloud. In th...
Overview As I discussed in my last article Oracle Multi-tenant Application Containers Part-I, Oracle Database 12.2.0.1 introduces the concept of multi-tenant application containers that enable many PD...
This is the third part of series of blog posts on 'How the EU GDPR will affect the use of Machine Learning‘ The new EU GDPR has some new requirements that will affect what data can be used to ensure ...
Aurora is a scalable, MySQL-compatible, RDS-managed relational database designed for high read and write performance and high transaction response time. An Aurora cluster consists of a primary node (...
Hi, I have a lot of PL/SQL tips to share. Here’s a first installment—perhaps more to come! Tip #1 The first thing I encourage all to use is %TYPE and %ROWTYPE on your variable definitions. In yes...
