Oracle SQL Developer version 18.4 is now available!
Installing Sample Data for Oracle Database
How to quickly add free, public data to your Oracle Database using Oracle SQL Developer.
Your Favorite Posts from 2018
Your favorite Oracle SQL Developer posts from 2018.
How to Export Your RESTful Services
You’re using ORDS. You’ve written some web services. Now you need to control the underlying PL/SQL source. How do I get the code out? There’s a few ways. 1. Use SQL Developer On the Module, mouse right click. 2. Use SQLcl The REST command will get what you want. If you want this in a file, just use the SPOOL …
Executing PL/SQL with Array INPUTS via ORDS
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: CREATE TABLE CONTACT ( NAME VARCHAR2(30 BYTE), PHONE VARCHAR2(20 BYTE), SOMETHING …
All of the Tuning Features in SQL Developer (2018)
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 …
Scheduling Exports of Your Data Using the Cart
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 …
INFO vs DESC – Learning About your Oracle Schema Objects at the Command Line
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 …
Learn More about SQL Developer and ORDS…in England and Belgium!
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 …
Oracle SQL Developer Version 18.4 Sneak Peek
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 [email protected] @OracleSQLDev #sqldeveloper pic.twitter.com/8zyfquqxZ6 — Tobias Arnhold (@tobias_arnhold) November 15, 2018 The short answer is, that …