Tag: Toad for Oracle

How to alter a table in Oracle?

Three different ways to determine Oracle database size.

How to add a column to table in Oracle Database.

The differences between a primary key vs foreign key.

Unit testing best practices with Toad for Oracle.

The SELECT statement is used to query Oracle Database table data, whether from a single table, or when used to query multiple tables.

Data masking is a technique used to hide data by obfuscating it when needed. Masking removes the identifying characteristics of data, so cannot be identified. Put simply, data masking anonymizes the data.

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 operations, check boxes, and selection drop downs.

Explore the top 5 Toad for Oracle features that set it apart and add value to daily tasks, including the Editor, Schema Browser and Session Browser.

In this post about database sequences, our expert explains the Oracle CREATE SEQUENCE statement, its attributes and how it can be used in different situations.