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 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 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...
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...
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...
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...
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...
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...
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...
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...
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). ...
Are you considering migrating some of your Oracle workload to the cloud? Here’s why you should consider Quest SharePlex to help you reduce downtime and mitigate risk; and why Azure is worth considerin...
