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...
Code Tester for Oracle 3.3
Code Tester for Oracle 3.3
Code Tester for Oracle 3.3 is now GA! We recently released a new version of Code Tester for Oracle which provides the following enhancements: A front end debugging option was added to the CTO tracin...
Oracle PL/SQL Performance Tips – Coding Best Practices – Part 8
Oracle PL/SQL Performance Tips – Coding Best Practices – Part 8
Hi,This article will discuss some PL/SQL performance tuning tips as well as make reference to a variety of good coding practices. There are several things you can do to get your PL/SQL code to run op...
Getting to Know the Toad for Oracle Schema Browser
Getting to Know the Toad for Oracle Schema Browser
The Schema Browser is an interface that allows us to work with various objects in the database. To learn about this interface, we first open Toad and connect to a database schema. For this example, w...