Toad templates
Toad templates
DID you know that TOAD comes with a ton of code templates? These templates often have substitution variables as well. CTRL+ Space bar signals ALL of the templates. You can type in a template name,...
How to export & import Unified Audit Trail in Oracle 18c
How to export & import Unified Audit Trail in Oracle 18c
Oracle Database 12c introduced the unified audit trail feature, which allows the capture of audit information from several sources, such as audit records (including SYS audit records) from unified aud...
Encrypt database link passwords with Data Pump in Oracle 18c
Encrypt database link passwords with Data Pump in Oracle 18c
Before Oracle Database 18c, the only way to encrypt data (all types of data) was using the parameters ENCRYPTION_PASSWORD or ENCRYPTION_PWD_PROMPT. The data is exported in clear text in an export oper...
How to Install Oracle Database 18c on Windows
How to Install Oracle Database 18c on Windows
In this article we will learn how to install Oracle Database 18c on Windows 10 Enterprise for research and education. Before we start installing, we need to know the minimum requirements for Oracle D...
Debugging PL/SQL Code with Toad for Oracle
Debugging PL/SQL Code with Toad for Oracle
In this article we will learn how Toad for Oracle can help us debug PL/SQL code in very simple ways, allowing us to go through the code a line at a time, view variable content, start or stop execution...
Toad for Oracle – How to change the editor font?
Toad for Oracle – How to change the editor font?
Go to View –> Toad Options Go to Editor –> Font and Styling in the left menu Make any changes to colors, fonts, and font sizes for various types of content In early releases: Go to the Editor→Behav...
Writing Queries in Toad Data Point
Writing Queries in Toad Data Point
Whether you want to write queries directly with in the SQL Editor or if you want to build queries through the drag-and-drop interface of the Visual Query Builder, Toad Data Point has deep query functi...
Getting Started with Toad Data Point
Getting Started with Toad Data Point
Whether you are new user or are just looking for a refresher, these resources will help you get the most out of Toad Data Point. If you have any questions on this content or other areas of functional...
Snorkelling in the Oracle Listener Logs.
Snorkelling in the Oracle Listener Logs.
(Snorkelling is not quite as in depth as a “deep dive”!) Attempting to parse a listener.log will probably bend your brain, but I needed to do it recently to determine which unique servers and/or desk...
IMPDP Hangs, or Appears to Hang – But Has it?
IMPDP Hangs, or Appears to Hang – But Has it?
You know the score, you are running an impdp and it looks to have hung up. You’ve watched the log file (or on screen messages) and it’s sitting at something like: Processing object type TABLE_EXPORT/...
Toad vs. SQL Developer
Toad vs. SQL Developer
Hi, This article hopes to compare Toad v13.0 and SQL Developer v18.1 a bit. Since I work with both tools in my training business, people often ask me to point out the differences in the two. I hope to...