How to get Oracle SQLcl to generate the DDL for an Oracle USER account.

When building your RESTful (Web) Services in ORDS, you assign a ‘Source Type’ for your handlers. What you pick here is important, but when in doubt, probably go with Collection Query. The selection you make here has a big impact on how ORDS formats the response. In general, you give us some SQL or PL/SQL. We execute it, get the response, and turn it into {JSON}. It’s a bit more complicated than that though, so…

Eight minute video demonstration of Oracle SQL Developer’s PL/SQL Debugger.

LIQUIBASE does ‘Source Control for your Database.’ It’s an Open Source project that allows you to capture changelogs for your database, including Oracle. What we are doing: Extending the support for Oracle to include all schema object types Building an interface directly into SQLcl via a new LB (LIQUIBASE) command Generating the changelogs for you and managing rollbacks plus the ordering for the changelogs to avoid database object dependency errors. A Quick Demo I said…

You have some data in an Oracle Database in your data center or laptop or docker or VirtualBox or…you get the idea. And, you have an Autonomous Data Warehouse or Transaction Processing (ADW & ATP) Database running in the Oracle Cloud. How do we get your data from your ‘old’ database up to your Cloud? If you have SQL Developer and access to Data Pump, then you can our wizards to make this a bit…

Why won’t the code helpers in Oracle SQL Developer work with my SQL or PL/SQL?

Oracle REST Data Services version 18.4 and your bug fixes are now available.

How to navigate your SQL Worksheet in Oracle SQL Developer using numbered bookmarks.

Oracle SQL Developer version 18.4 is now available!

How to quickly add free, public data to your Oracle Database using Oracle SQL Developer.

Your favorite Oracle SQL Developer posts from 2018.

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 command. 3. Get it Yourself with SQL The ORDS_METADATA schema comes with some PL/SQL packages…

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: 2196126685c6b8881419f0_000003 Executing FORUMS_PLSQL_TABLE.INS_C() via POST First, let’s Auto PL/SQL Enable the Package. 2196126685c6b8881419f0_000004 Second, let’s call the package. 2196126685c6b8881419f0_000005 So in my POST I passed a…

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…

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…