What is a DDL Script, and why it is useful
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...
Advanced Table Joins and Data Sorting with Toad Data Point
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...
Toad Training: 30 minutes, 1st and 2nd Tuesdays each month
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...
Using SQL Server Data Encryption in Toad for SQL Server
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, ...
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...
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...
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...