What is dynamic data movement?
Dynamic data movement includes replication of data from a traditional RDBMS like Oracle to databases like MySQL, Azure SQL Database, Kafka and PostgreSQL. Data is valuable because it contains all of t...
Free gift: Toad summer icon and wallpaper
Free gift: Toad® for Oracle Summer icon and wallpaper
Surf’s up! The Quest® Toad® is ready to hit the waves this summer. Refresh your screen and avatar with a Toad summer-theme. With all the time-saving tricks that Toad puts at your disposal, you be read...
Data to AWS Three Ways – A SharePlex Cookbook Part Two
Data to AWS Three Ways A SharePlex Cookbook Part Two In the first blog, I discussed data and a bit on SharePlex. Now for the recipes! Recipes Here are the recipes - three different ways to get data ...
Automated Code Review: Best Practices
Automated code review takes the tedious and time-consuming aspects of code review out of the task, but it still quite dependent on user input. In this article, we’ll discuss some of the best practices...
Why and How to kill a session in Oracle
If you are a Database Administrator (DBA), indeed, you have encountered the situation of needing to kill a session in the Oracle database. Many different situations can lead you to need to kill a ses...
How to alter a table in Oracle
This article explains how to use the ALTER TABLE statement to modify the oracle table. We are going to use an array of examples in order to learn how to alter a table in Oracle. We can perform the f...
Three different ways to determine Oracle database size
This article explains the different ways to determine Oracle database size. We are going to learn about the following topics: Populate the size using catalog views Populate the size of all pluggable...
How to add a column to table in Oracle Database
This article explains how to add a column to table in an Oracle database. After creating a database table, it may be needed to add additional columns as the table design evolves based on data requirem...
Toad Data Point Tutorials: SQL Table Joins
Introduction SQL table joins are common practice in the relational database world. They are a way of eliminating data redundancy and allowing the user of the data to select what they want from the dat...
KACE by Quest earns rave reviews for automating unified endpoint management
It’s one thing for us to tell you KACE® by Quest® improves unified endpoint management; it’s quite another for KACE users to be so impressed with the solution that they take the time to write rave rev...
The differences between a primary key vs foreign key
This article explains the fundamental concepts of a primary key vs foreign key, and also explains the difference between a primary key vs foreign key. What is a Primary Key The primary key is one col...
Unit Testing Best Practices with Toad for Oracle
Unit Testing Best Practices with Toad for Oracle
In this article we’ll discuss some of the best practices of unit testing. What is unit testing? Unit testing in Toad for Oracle is used to test PL/SQL objects (functions, procedures and packages). ...