Tag: ADB

  • Clean up a .CSV file with Regular Expressions, Pandas, and Python

    ,

    I want to load data via Database Actions in my Oracle Autonomous Database, but first I need to clean up some Dates and Times. Python is my language of choice, and I’ve heard about Regular Expressions, but I’m scared…

    A-more-formal-pattern-for-Regular-Expressions-Database-Actions-Oracle-Autonomous-Database-Chris-Hoina-Senior-Product-Manager-ORDS-Database-Actions
  • GET requests with Python, ORDS, and the Oracle Autonomous Database

    ,

    I needed an approach that would make me question my life decisions. Something that would force me to rethink what it meant to be human.

    Objects-in-SQL-Worksheet-in-Oracle-Autonomous-Database-Chris-Hoina-Senior-Product-Manager-ORDS-Database-Tools-
  • Updating VARCHAR2 fields in Oracle Database Actions

    Update I’ve run into more problems with this python/flask/ords/adb app idea of mine. Turns out I’m too [developer] dumb to do some of the things that I’d originally envisioned. Now that I’ve become more familiar with python, flask, the Oracle Autonomous Database, and our Database Tools (like ORDS and Database Actions), I’m realizing that I…

    Developer-Radar-Chart, Chris Hoina, Senior Product Manager, ORDS, Database Tools
  • Add Primary and Foreign Keys to your Oracle Autonomous Database

    I’m not a Database Administrator, but I feel as though I may be slowly evolving into one… In a previous post, I left myself the task of correcting the html on a proposed Python/Flask/ORDS/Autonomous Database application. My then next step was to add a search bar (which I did): Although this was a small step…

    New-Diagram-of-tables-in-the-Data-Modeler-Diagram-Editor-in-Database-Actions-in-Oracle-Autonomous-Database-Chris-Hoina-Senior-Product-Manager-Database-Tools-ORDS
  • Project Overview: python – flask – ORDS – Autonomous Database

    , ,

    Update For the past week and a half I’ve been immersed in learning how python and flask interact with each other so a developer can create a quick/crude web application. I’ve also spent time becoming more familiar with virtual environments (as they pertain to python + flask), jinja, and WTForms (I’m sure I’m forgetting other…

    Explaining-my-python-flask-Autonomous-Database-and-ORDS-API-project-1
  • Create a user in Oracle Autonomous Database [for Dummies]

    Creating an additional user in your Oracle Cloud Infrastructure (OCI) is not the same thing as creating an additional user in your Autonomous Database (ADB).

    Database-Actions-in-Oracle-Autonomous-Database, Chris Hoina, Senior Product Manager, ORDS, Oracle Database Tools
  • Table Prep: Data loads and time zones

    With my Autonomous Database up and running,I needed to find some data to upload.

    Restaurants in Wake County, North Carolina. Wake County is where I, Chris Hoina, live.
  • An Oracle Autonomous Database workshop: here is what I learnt

    “…For someone who isn’t familiar with System or Database Administration, this was helpful and it made approaching ‘infrastructure’ so much more accessible and seemingly less daunting…”

    Water cooler talk. A junior Science Officer recants his experience on the Oracle Cloud, to a Bridge Officer.
  • Hello World 🙂

    WARNING: Turn back now. You have been warned.  Who am I? I’m Chris Hoina. Senior Product Manager at Oracle as (still not sure why they hired me, most likely a clerical error). I’m a recent “Big Blue” defector; at IBM for nearly three years. There I worked in IBM Z (the mainframe, Big Iron, or…