Mostly Making oracle easy, mostly:
Search for:
I’m new to Oracle, and I need a database…help!
Database Stuff

I’m new to Oracle, and I need a database…help!

Taking an Oracle Database class or course? Need to get up and going on Oracle Database really fast, and really easily? Here’s my advice!

Read More
REST APIs and TABLE INSERTs: the Definitive Guide for Oracle
ORDS

REST APIs and TABLE INSERTs: the Definitive Guide for Oracle

REST APIs and TABLE INSERTs, everything you need. Bonus: we’ll build a REST API to GET the data, with support for CLOB/JSON, links, and exception handling!

Read More
Sell Me on Oracle SQLcl in 50 Seconds
SQL Developer

Sell Me on Oracle SQLcl in 50 Seconds

Why would I use SQLcl…

Read More
ORDS
In ORDS

Executing PL/SQL with Array INPUTS via ORDS

1 Min Read

Today’s question: Does ORDS support PUT/POST with Array or Cursor as part of the payload? I need to call a procedure with 1 IN parameter defined as Array or Cursor (for a list of IDs). The answer is Yes, and I’ll show with the AUTO Feature. The Underlying Code: 17289610686875959c4a552_000001 Executing FORUMS_PLSQL_TABLE.INS_C() via POST First, let’s Auto PL/SQL Enable the Package. 17289610686875959c4a552_000002 Second, let’s call the package. 17289610686875959c4a552_000003 So in my POST I passed a…

SQL Developer
In SQL Developer

All of the Tuning Features in SQL Developer (2018)

2 Mins Read

Slideshare won’t let you update slide decks anymore, so I just uploaded my latest version as a new offering. All of the Performance Tuning Features in Oracle SQL Developer, 2018 Edition from Jeff Smith I’ll be presenting this topic at UKOUG this week. if you’d like me to present this to your group of the developers and administrators, drop me a note, and we’ll setup a webinar. A Custom Design Rule – Do I Have…

SQL Developer
In SQL Developer

INFO vs DESC – Learning About your Oracle Schema Objects at the Command Line

1 Min Read

Here’s an 8 minute video walk through of using INFO and DESC in Oracle SQLcl. You can decide what works better for you – hey, maybe you’ll decide to use both! INFO shows more info INFO+ shows more info with more stats You can INFO a package OR a package.procedure Enjoy! PS – I made this on my new rig Mac Mini, 4k screen, but I filmed for 1080p resolution. I’m also using a new…

Database Stuff
In Database Stuff

Learn More about SQL Developer and ORDS…in England and Belgium!

2 Mins Read

The 2018 conference season is winding down. Next week is DOAG in Germany – an amazing conference by the way – and a short time after that is the UKOUG Tech 2018 conference in Liverpool, England. This will be my second experience presenting at UKOUG, and I’m looking forward to reconnecting with old friends and meeting new folks – all while talking about ORDS and SQL Developer. The Tuning in SQL Developer talk is a…

ORDS
In ORDS

Video: Building REST APIs for Uploading & Downloading Files

4 Mins Read

This video is a bit longer than most, but I’ll show you how to deploy a web service to: get a list of files from a table – stored as BLOBsget individual file detailsdownload/render the file using the mime typeupload a filegenerate LINKs in your {json} responsesset the HTTP Status Codes for your responses The Video Skip the Intro, Go Straight to the Demo. The Slides Build a Web Service to Up and Download Files…

SQL Developer
In SQL Developer

Query Builder: Where Are My Joins?

3 Mins Read

One of the improvements for version 18.3 was a much improved, performant query builder. Of course, not all things are free. Or in fact, nothing is free. So who paid for these performance gains? We disabled one of its primary features. But first, let’s take a step a back and explain the scenario. How it Was, Pre 18.3 The query builder would allow you to reverse engineer a query in a worksheet to a visual…

ORDS
In ORDS

Preventing 500 Status Codes with Oracle REST Data Services

6 Mins Read

This topic is so epic, it has a part two, deeper look (more examples, mostly.. In my Oracle REST Services Demos I always show things working exactly as planned. But what happens when your user does something your program doesn’t expect? Or what happens when you code does something you don’t expect? In the web (HTTP) world, you get a 500. 10.5.1 500 Internal Server ErrorThe server encountered an unexpected condition which prevented it from…

SQL Developer
In SQL Developer

All of Your Objects: Reports

2 Mins Read

Today’s question: I am looking for a way to list out all and count all objects by all schema, any idea? So the connection tree is nice in that it makes it easy to see specific types of objects by schema – but if you want a FLAT view of a schema, it’s not so great. Ok, so what’s a SQL Developer user to do? Try our Data Dictionary Reports The Reports panel is there,…

SQL Developer
In SQL Developer

Yes, SQL*Loader is Faster at Loading Records

4 Mins Read

Someone asked on StackOverflow how to get loading a 1,000,000 records to be faster in SQL Developer. My answer was basically, don’t use SQL Developer to load 1,000,000 records, use SQL*Loader. Now, I also reminded folks that you can USE SQL Developer to build your SQL*Loader scenario. There’s 2 ways actually: Query existing records, export to Loader (Keep Reading this post!) Point to a CSV, and use the Import Data Wizard But Wait, What is…

SQL Developer
In SQL Developer

Data Modeler Tip: Assigning a SCHEMA to Your Objects

3 Mins Read

Was helping someone on Stackoverflow this morning, and thought you might enjoy seeing this process as well. PROBLEM: You’ve created a schema script, you’ve generated the DDL, and you ran it on your brand-spankin’ new database. Except. Except, you ran that script as SYS, and your schema scripts didn’t have a SCHEMA defined. So you’ve corrupted your SYS schema!!! How to fix that (FLASHBACK!) is a different post. This post is about how to assign…