Using a SQL Alias
Before learning how to find a database alias using Toad for Oracle, it is essential to understand what an alias is in SQL. What is a SQL alias? SQL database aliases are used to give a table,...
Before learning how to find a database alias using Toad for Oracle, it is essential to understand what an alias is in SQL. What is a SQL alias? SQL database aliases are used to give a table,...
This article explains what DDL scripts are and how to use them. The script can contain various PL/SQL DDL commands used to create database objects and establish the relations between them. The abbrevi...
Start planning now to attend Quest EMPOWER 2022 We’re excited to announce Quest EMPOWER 2022, a free two-day online summit designed to inspire you and help you identify new strategies to move your dat...
Introduction Table joins are a helpful function to get familiar with in Toad Data Point. What happens if you need to relate two different rows within the same table? In the EMP table, we have employee...
Growth of open-source databases Database developers and DBAs have been using open-source databases, such as MySQL and PostgreSQL, for years. The platforms are mature, offer flexibility with low lic...
It’s double the fun when you attend Quest® Toad® for Oracle and Toad Data Point free training! Get personalized tech advice from industry experts in our Toad Training Tuesdays. Our tech gurus are t...
Our NEW webcast series is directed specifically at existing SharePlex product users. We call the series, “SharePlex Skills 101”, where we present topics that have a broad interest among administrators...
SQL Server supports data encryption to encrypt, or obfuscate, data so that confidential data may be protected. Data encryption is provided using Transact-SQL functions, passwords, cryptographic keys, ...
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...
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...