Tag: SQLcl

  • Tinkering: a SQL script for the ORDS_ADMIN.ENABLE_SCHEMA procedure

    , , , , , , , ,

    Post-ORDS installation Once you’ve installed ORDS, you need to REST-enable your schema before taking advantage of ORDS (I used to forget this step, but now it’s like second nature). RESOURCES: I’ve discussed ORDS installation here and here. I’d check both pages if you’re unfamiliar with it or want a refresher. ORDS.ENABLE_SCHEMA / ADMIN_ORDS.ENABLE_SCHEMA While logged into your…

    initial-input-section-of-script-vs-code-chris-hoina-senior-product-manager-ords-oracle-rest-apis-database-tools-podman
  • ORDS install considerations: choosing the correct host, port, service name, and pluggable database when the database is in a podman container

    , , , ,

    The other day, I wrote about how I had to start from scratch on my podman containers 😢. I’m now at the step where I need to reinstall ORDS in these two new database containers (21c and 23c). And since I’m doing this install yet again, I figured I would point out some things I’ve…

  • User Guide: Oracle database in a Podman container, install ORDS locally, and access a SQL Worksheet on localhost

    , , ,

    Summary The title says it all. I’ve run through this about ten times now. But I’ll show you how to start a Podman container (with a volume attached) and install ORDS on your local machine. And then, once installed, we’ll create and REST-enable a user so that the user can take full advantage of Oracle…

  • Podman, Oracle Container Registry, and SQLcl

    , , , ,

    Containers are kind of like terrariums.

    one-more-thing-chris-hoina-senior-product-manager-oracle-database-tools-oracle-cloud-ords-oracle-rest-apis-sql-developer-podman-sqlcl
  • An intro to using Oracle SQLcl on Mac

    Did you know you can use Homebrew to install Oracle’s SQLcl on Mac? I just realized this about a week ago (always the bridesmaid, never the bride…amirite??). Homebrew First you’ll need to install Homebrew (I’m sure there are other ways to install SQLcl, but installing through Homebrew was a breeze). You can install Homebrew on…