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
SQL Developer

This post won’t show you how to acutally do the scheduling bits – I’m going to assume you know how to use contrab or Windows Scheduler -but I will show you how to get SQL Developer setup so that you can call it from the command-line to do your export. Our requirements – from an AskTom question – I want delimited text output, TABs the numbers need to be quoted I’m running on Windows BUT…

SQL Developer

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…

SQL Developer

So someone asked us on Twitter this morning about a new Document that opens on an Export of a query result set. How can I prevent the "Export Tool" log in SQL Developer 18.3?I get it whenever I create some DDL over the navigation menu.@oraesque @OracleSQLDev #sqldeveloper pic.twitter.com/8zyfquqxZ6— Tobias Arnhold (@tobias_arnhold) November 15, 2018 The short answer is, that wasn’t intentional – it’s a BUG. Good news – we HAVE cleaned that up for version…

ORDS

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

This was one of my 3 sessions at Open World last week. None of them were recorded, but I figured you might find this one interesting, so I ran through the slides again here. If you search this blog for things like ‘18.1’, ‘18.2’, and ‘18.3’, you can find all the blog posts I put together showing some of these features. But a short list would definitely include: SQL Injection Detection Faster Query Builder &…

ORDS

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 case you haven’t figured this out by now, 90% of my material here is generated by questions from folks like you out there. So thanks for the never ending supply of content! And it gives me an opportunity to keep learning as well! So the question: I believe this json data type in MySQL would probably map to either CLOB or VARCHAR2 in Oracle. Is this something which can be achieved by defining custom…

SQL Developer

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

Things to know: MANY bug fixes The Windows Embedded JDK is now Version 8 update 181 You can have nested connection folders in the main and DBA connection panels Real Time SQL Monitoring reports can be exported to (non-flash) HTML Connections Some of you out there work with MANY databases, and so of course have tons of connections to work with in SQL Developer. Now you can have as many levels of folders as you…

SQL Developer

Why would I use SQLcl over something else? History recap: we introduced a new command-line interface for the Oracle Database in 2016. It’s everything you like about SQL*Plus, and everything you didn’t like about SQL*Plus – fixed. Do you have a minute? Watch this, then take 10 seconds to consider how YOU might use it. Everyday Things, Easier Just in 50 seconds I showed you: Object completion In-line editing Automatic SQL Formatting (pretty and CSV)…