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, ...
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...
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...
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...
It is often necessary to assign integer column values that are in sequence across different rows of data in a relational database. Oracle Database provides Oracle Sequence for creating a sequence of i...
If you use the DATEdata type in your SQL code, it is likely that you have come across the “not a valid month” Oracle database error. As we shall discuss, the error can be fixed with a slight tweak of ...
The object model for developing database object types and object tables brings object-oriented data storage to Oracle Database. In a previous post, “How to create database objects with Toad for Oracle...
In database parlance, batch jobs consist of multiple programs, PL/SQL procedures or SQL scripts run together in a sequence, optionally against multiple databases. An individual job is not much differe...
Oracle Database supports database objects in the relational model and uses object types to convey the concept of the objects. An object type definition consists of an object specification and an objec...
Quest® Toad Edge® provides an integrated development environment to connect to open source databases MySQL and PostgreSQL and run SQL scripts. In three articles we will explore migrating a commercial ...
