SQLcl: Customizing on a Mac

In this post I will summarize the steps I’ve taken to customize SQLcl on my Mac working environment. We assume that the reader is familiar with the procedures outline din … More SQLcl: Customizing on a Mac

Only on Windows: SQL Developer 23.1 and the Instant Client!!

If you require a ‘thick’ connection in SQL Developer 23.1 running on Windows, you’ll need to either: Use a 21c Client Use the 21c Instant Client with… SQL Developer 23.1 … More Only on Windows: SQL Developer 23.1 and the Instant Client!!

SQLcl: Setup on a Mac

Simple and straightforward steps about how to setup Oracle’s new SQL command line tool on a macOS X environment. Download Application and Environment Setup Attempt to start the application: Setup … More SQLcl: Setup on a Mac

BUG? Oracle SQL Developer cannot access files on mac OS X

I used Oracle SQL Developer for years until recently (possibly after the upgrade to macOS 12.6.5?) when the SQL Developer stopped being able to access the files stored locally: The … More BUG? Oracle SQL Developer cannot access files on mac OS X

Oracle SQL Developer 23.1 is now available

It’s time to go update your desktop copy of SQL Developer! We have some very important bug fixes for our community of Oracle Database users, … Oracle SQL Developer 23.1 … More Oracle SQL Developer 23.1 is now available

Problematic Statistics of the Application Objects in your Oracle Database

One of the often asked questions is to find out the status of the statistics of the application owned schemas. In this article, I will list the SQL code that … More Problematic Statistics of the Application Objects in your Oracle Database

SSB Schema creation on Oracle DB by using Autonomous and SQL Developer

Creating the empty SSB database objects on Oracle … More SSB Schema creation on Oracle DB by using Autonomous and SQL Developer

Comparing Oracle Databases: Initialization Parameters

A method for comparing the Oracle init parameters of several PDB’s … More Comparing Oracle Databases: Initialization Parameters

TUE Post: Use Oracle SQL Developer to move data between databases

Use INSERT hint with SQL Developer … More TUE Post: Use Oracle SQL Developer to move data between databases

Tuesday Post: Database schemas compare

One of the questions that arise during the development process is if the database schéma I work on is an unaltered image of production. How do I know that another … More Tuesday Post: Database schemas compare

Oracle SQL Developer 21.4.2 & SQLcl 21.4.1 are now available

We published two updates last night, both maintenance releases, aka bug fixes only. Released January 19, 2022.That being said, everyone should … Oracle SQL Developer 21.4.2 & SQLcl 21.4.1 are … More Oracle SQL Developer 21.4.2 & SQLcl 21.4.1 are now available

Help, my Oracle SQL Developer is crashing!

With 7,000,000 users, give or take a million, I get quite a few notes from folks who are having problems getting SQL Developer to open, or to STAY … Help, … More Help, my Oracle SQL Developer is crashing!

Starting Oracle SQL Developer with Custom Parameters

I recently worked at a Client that had the Windows desktop setup in a non-English language. Naturally, I did not get admin rights on the Client owned desktop so I … More Starting Oracle SQL Developer with Custom Parameters

Setup a VirtualBox based Database Lab Environment

Oracle provides a lot of useful Oracle VirtualBox Pre-built Appliances. In this blog post, I will describe the few extra steps I take after download in order to setup my … More Setup a VirtualBox based Database Lab Environment