Welcome one and all to my new professional blog, tobybase.com. My name is Toby Marks and I work as a Oracle Consultant at Infolob Solutions in Irving, Texas. My old blog is still up on Tumblr, and there are a few items there that folks still find useful. Most of the content is a bit dated, though, as I’ve been out of the blogging game for a while. This is my attempt to turn that around.
Read more


If you use Juniper’s Network Connect app to connect to your office VPN over HTTPS, you might occasionally experience strange errors like “A software error caused the Network Connect tunneling service to terminate.” Shortly after that, the application may either crash or prompt you for login credentials again. The solution involves removing all of the Network Connect files and allowing your browser to download and install the app all over again, as it did the first time you tried to connect to your office VPN.
Read more


The ps command is a versatile and configurable way to look at the processes running on your system, though I’ve generally gotten by with a lazy ps -ef to find out whatever I needed to know. Recently, though, a client’s server began running out of memory, and as a number of processes were running on the server, the culprit was not immediately clear. I wanted to provide them with a quick, simple diagnostic tool they could use the next time they received an alert.
Read more

07/24/2013   Linklog:  Anonymous: Use Preview to view formatted man pages

This is an elegant solution for viewing, searching, and archiving man pages that eliminates the necessity for third party apps.
Update: still works in macOS Sierra.



I just purchased a new Macbook Pro 13-inch with Retina Display and was horrified to see how fuzzy SQL Developer looked on the high-res screen. Thanks to Thunderforge on the Stack Overflow forums for this tip: Java 7u40 Early Access now supports HiDPI (Retina) displays, as shown by this changelog. So retina support is now available on Java 6, Java 7u40 or higher, and Java 8. I am currently running the Early Adopter release of SQL Developer 4.
Read more


Under normal circumstances, it is fairly easy in Microsoft Word to reset page numbering when starting a new section of your document. However, such a simple thing can be non-trivial when dealing with the BI Publisher Template Builder plugin for Microsoft Office (available from Oracle — see BI Publisher Desktop). In short, doing this the normal way did not work for me, and in researching the issue I ran across a number of folks who were having the same problem.
Read more


In Windows, most applications provide menu and button accelerator keys that allow you to control the application without having to use a mouse. Java Swing apps like SQL Developer allow you to do the same, ostensibly in a cross-platform compatible manner. One place I use this frequently is the Enter Binds dialog window that pops up when running a query using bind variables. In Java 6 on OS X, the hotkey for pressing the Help and Apply buttons was OPTION-H and OPTION-A, respectively.
Read more


Using Jaspersoft’s free iReport Designer tool and the open source PL-JRXML2PDF project, you can generate PDF reports from Oracle Apex for free, without having to install the JasperReports and JasperReports Server components. Watch my video tutorial to find out how.
Read more


Oracle’s external table feature allows you to treat structured files on the database server as tables for query and DML purposes. To use an example from the linked documentation, a tab-delimited file like this: 56 november, 15, 1980 baker mary alice 09/01/2004 87 december, 20, 1970 roper lisa marie 01/01/1999 …could be queried like this: SELECT employee_number, employee_first_name, substr(employee_middle_name, 1, 1), employee_last_name, employee_hire_date, to_date(employee_dob,'month, dd, yyyy') FROM employees; After defining the external table like this:
Read more