Oracle REST Data Services version 18.4 and your bug fixes are now available.
Installing Sample Data for Oracle Database
How to quickly add free, public data to your Oracle Database using Oracle SQL Developer.
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 …
Demonstrating Oracle SQL Developer Web: CREATE & ALTER TABLE
In two previous posts, I have: Introduced Oracle SQL Developer Web and did a quick demo of the Worksheet Demonstrated the data modeler diagramming feature. Today, I want to show you our CREATE and EDIT TABLE dialogs. While I aim for 10 minute videos, I had to go into overtime, and came out at 13 minutes. But as a bonus, …
What Happens if I REST Enable a table with no Primary Key in ORDS?
When you AUTO-REST enable table in ORDS, we publish a full API for you: We auto find your Primary Key Column and use that to address particular rows (items) in your table (collection.) But..what happens if you don’t have a primary key? CREATE TABLE no_keys (letter CHAR(1), letters VARCHAR2(25), numbers INTEGER); INSERT INTO no_keys VALUES (’a’, ‘abc’, 1); INSERT …
AUTO vs ‘Bespoke’ REST Services
The Automatic REST features in ORDS are very handy for getting started quickly with providing REST APIs to your data and stored procedures. Give me the data for an employee. Easy. REST enable the schema. REST enable the table. DO a GET on /ords/schema/table/id. But…I don’t want a ‘null’ in my JSON collection for value pair “commission_pct.” What’s an Oracle …
Multi-Select Object Actions via XML Extensions
You want to drop, purge 10 tables, and you don’t want to select, click, click, click 10x. What’s a SQL Developer user to do? Well, if you want to live dangerously, you could build a custom extension for SQL Developer to do that for you. We tweaked the IDE to allow this in version 4.1.2 – if you’re on any …
Generating Table DDL via SQLcl, with and without Storage Clauses
I don’t like deleting blog posts just because they’re old, or no longer true, but this one came before we made this SO MUCH SIMPLER. Please read this post instead. TL/DR? You can now just say SET DDL STORAGE OFF if you want to set the metadata transform bits 🙂 We’re getting much closer to having Oracle SQL Developer version …
Adding Common Columns to Tables via Templates and Transformation Scripts
In Oracle SQL Developer Data Modeler, you can create a table in your relational design that stores columns that you want to be added to all of your other tables. Call it, ‘table_template.’ Now call the transformation script. Tools > Design Rules & Transformations > Transformations. Before After These are cool, but they don’t belong in my Logical model! So …
SQL Developer 4.1: Easier Excel Imports
The most read post on this site? ‘How to Import from Excel to Oracle with SQL Developer‘ – and it has been since I published it almost 3 years ago. People really like Excel. Or I should put it this way – Excel is the way information is shared in an organization. It makes no matter how much money was …