18.1 – New Formatting Option, Right-Align Query Keywords

thatjeffsmith SQL Developer 20 Comments

Due to popular demand, we’ve added this new preference to the formatter. With it turned on: On SELECT B.DEPARTMENT_NAME, A.FIRST_NAME, A.LAST_NAME, A.SALARY FROM DEPARTMENTS B, EMPLOYEES A WHERE A.EMPLOYEE_ID = B.MANAGER_ID AND B.DEPARTMENT_ID (+) = A.DEPARTMENT_ID ORDER BY SALARY DESC, LAST_NAME ASC; Off SELECT B.DEPARTMENT_NAME, A.FIRST_NAME, A.LAST_NAME, A.SALARY FROM DEPARTMENTS B, EMPLOYEES A WHERE A.EMPLOYEE_ID = B.MANAGER_ID AND B.DEPARTMENT_ID (+) …

Let’s talk about ‘Squiggles’ – What’s Wrong with Your SQL or PLSQL?

thatjeffsmith SQL Developer 1 Comment

SQL Developer’s code editors try to help you out. They’ll show you two categories of informational advisories: there is a problem with this code we think we can help you with this code These are shown by various styles of underlined text in the editor. Let’s go through the list of what’s available as of version 18.1 – to be …

Building An Object Search for SQLcl

thatjeffsmith SQL Developer 0 Comments

The search feature in SQL Developer is whiz-bang. You’re using it, right? But what about at the command line? I’m guessing many of you just pluck away at ALL_ or DBA_OBJECTS. Some of you may have written some custom scripts. But, what if you burned that into SQLcl? You can of course do this with the ALIAS command. You can …

What Happens if I REST Enable a table with no Primary Key in ORDS?

thatjeffsmith ORDS 1 Comment

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

thatjeffsmith ORDS, SQL Developer 3 Comments

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 …

On Running Oracle Scripts with Relative Paths

thatjeffsmith SQL Developer 0 Comments

A customer ‘ambushed me’ – how dare they!?! – at the conference today, needing help getting their scripts to work. So something like this: And the way the customer wants to run scripta.sql (which calls scriptb.sql) So, where is SQL Developer going to look for scriptA? And when it gets to the @child\scriptb.sql? We can call scripts.sql using @c:\users\jdsmith\desktop\parent\scriptA.sql But, …