An Oracle Designer Feature: Generating Table APIs with Oracle SQL Developer

thatjeffsmith SQL Developer 27 Comments

Have you heard of Oracle Designer? Perhaps you even still use it? Designer incorporates support for business process modeling, systems analysis, software design and system generation. I don’t want to get you too excited, because this technology is being phased out. You can read the official statement of direction here, but but going forward we’re recommending you use JDeveloper, Fusion, …

Quick Outline: Navigating Your PL/SQL Packages in Oracle SQL Developer

thatjeffsmith SQL Developer 14 Comments

If you’re browsing your packages using the Connections panel, you have a nice tree navigator to click around your packages and your variable, procedure, and functions. But What if you drill into your PL/SQL source from the worksheet and don’t have the Tree expanded? Let’s say you’re working on your script, something like – So I need to reacquaint myself …

Inspecting PL/SQL Collections with Oracle SQL Developer

thatjeffsmith SQL Developer 14 Comments

Our stored procedures often capture information and store that data as a string or number. But sometimes we need to process more than just a single value. PL/SQL allows you to do this via collections. Now, if you’re looking for help getting started with collections, I would start with Using PL/SQL Collections and Records Oracle Docs The PL/SQL Guru, Steven …