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...
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). ...
Using Toad® for Oracle to Query Multiple Tables
Using Toad® for Oracle to Query Multiple Tables
The SELECTstatement is used to query Oracle Database table data, whether from a single table, or when used to query multiple tables. To query multiple tables, the tables are specified in the FROMclaus...
SQL Basics with Toad® Data Point
SQL Basics with Toad® Data Point
The better you know SQL basics, the better you can perform your job by being able to access relational data using the SQL language, or by tweaking the SQL produced by Query Builder. This series will...
Data Masking in SQL: What it is and why it’s important
Data Masking in SQL: What it is and why it’s important
With the ever-increasing use of relational databases in routine tasks such as storage of retail store transactional data, financial transactional data, sales data and employee data, it has become impo...
Tips for Using Toad for SQL Query Generation
Tips for Using Toad for SQL Query Generation
Toad has always had Query Builder with SQL query generation functionality. This feature is more for the novice to the SQL language and allows people to build robust SQL using just drag and drop operat...
SQL Pattern Matching in Toad Data Point
SQL Pattern Matching in Toad Data Point
SQL allows for the selectivity of character data with a specific pattern and NOT in a specific pattern. Either way, pattern matching syntax will always be useful when sifting through your extensive da...
Please vote before May 11! 2022 DBTA Reader’s Choice Awards
Please vote before May 11! 2022 DBTA Reader’s Choice Awards
We need your help! Year after year, customers vote Quest® products as their #1 choice in database solutions. It's voting time again. Please help us keep our #1 position in 2022. Voting is going on n...
Toad Data Point Tutorials: SQL Where Clause Null Values
Toad Data Point Tutorials: SQL Where Clause Null Values
Null values in a column are neither zeros nor spaces, although they appear to be spaces since the field is blank. Technically, null values are low values or Hexadecimal zeros. So, how do you know if...
Toad Data Point Tutorials: Data setup, code snippets and SQL Recall
Toad Data Point Tutorials: Data setup, code snippets and SQL Recall
Learning SQL with Toad Data Point Learning SQL can be a challenge, but one that’s made much easier by using tools that make finding, preparing, extracting and reporting on data simple. By accessing r...
The top 5 most used Toad® for Oracle features
The top 5 most used Toad® for Oracle features
Almost every software tool has distinct features that set it apart and make it a value add to daily tasks and Toad for Oracle® features are no exception. In this article, we will explore and give an o...