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…
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.
Oracle SQL Developer version 18.4 is now available!
How to quickly add free, public data to your Oracle Database using Oracle SQL Developer.
How to export your Oracle REST Data Services (ORDS) modules to PL/SQL scripts/files that you can put into source control or just backup.
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: 15985375386648d3ffa59a9_000002 Executing FORUMS_PLSQL_TABLE.INS_C() via POST First, let’s Auto PL/SQL Enable the Package. 15985375386648d3ffa59a9_000003 Second, let’s call the package. 15985375386648d3ffa59a9_000004 So in my POST I passed a…
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…
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…