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...
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 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...
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). ...
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...
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...
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...
