Sqlplus Download Mac

SQL.Plus Commander is Text-based user interface (TUI) / framework to query data on Oracle DB in a smart way. It consists in a fully customizable script shell for bash and ksh. It executes custom queries or procedures on DB with SQLPlus for Oracle. Oracle sql plus free download - Insight Developer for Oracle, SQLite Database, Orac, and many more programs. Installing SQLite on your Mac is pretty straightforward. Just follow these steps: Head over to SQlite.org and download the C source code file, named sqlite-autoconf-3130000.tar.gz or similar, from.

SQL Database Pro for Mac relates to Developer Tools. The most popular versions among the program users are 2.2, 2.1 and 1.2. This software for Mac OS X was originally designed by Impact Financials, Inc. This app is suitable for Mac OS X 10.8 or later. Our built-in antivirus checked this Mac download and rated it as virus free. From the developer. Sep 25, 2020 Next, extract the second zip file instantclient-sqlplus-macos.x64-19.3.0.0.0dbru.zip we’ve downloaded from the previous step. It will produce a new folder called “instantclient193”, the same as the previous zip file.

Have you ever tried to spool/download BLOBS with SQL*Plus? Some months ago I tried to find a way to download a collection of CLOBs or even better a zipped version of the collection as BLOB. I learned that BLOBs are not a valid datatype in SQL*Plus when it comes to the spool command. I found a way by putting the CLOBs into a global temporary table, creating an intermediate SQL script with tons of select and spool commands, and finally spooling the CLOBs one by one by calling the intermediate SQL script. It was working, but far from elegant. Also, when I was in the home office with a less powerful connection, it was slowing down the whole export process significantly.

If you are using PLEX (PL/SQL Export Utilities) and this sounds familiar to you - the described method was the default for exporting an APEX app or your schema DDL with the delivered export script templates.

Sqlplus

If you have no idea what I am talking about: PLEX is a PL/SQL package that is able to export an Oracle APEX app, ORDS modules, all schema objects and table data into a nice directory structure in one go ready to use for version control. Check out the project on GitHub and this blog post on how to get started.

But there is a better way: Simply convert the BLOB into a base64 encoded CLOB. I have no idea why this was not my first solution for the PLEX export templates. In the new version 2.1.0 of PLEX the templates are using this approach. Here is a simplified example.

Sql

Download Sqlplus Client For Windows

File export.sql:

Sql Plus Free Download

Congratulations - You are the owner of a base64 encoded CLOB on your client disk. And now? Before you can unzip the file you need to decode it - depending on your operating system you can do this with your OS tools:

  • Windows: certutil -decode app_100.zip.base64 app_100.zip
  • Mac: base64 -D -i app_100.zip.base64 -o app_100.zip
  • Linux: base64 -d app_100.zip.base64 > app_100.zip

Here a simple Windows batch file, which calls the SQL script above, decodes the file and deletes the base64 version.

File export.bat

Sqlplus Download Mac

Sql Plus Download Mac Version

The described method to download a BLOB is independent of the package PLEX - you only need a small helper function to encode the BLOB. I found an example provided by Tim Hall on his Oracle Base site. Thanks for sharing Tim!

Sql Plus Download Oracle

This function is included in the newest version of PLEX (named to_base64) - you can download PLEX here.

Happy scripting, exporting and version controlling :-)

Ottmar