I’m new to Oracle, and I need a database…help!
Database Stuff

I’m new to Oracle, and I need a database…help!

Taking an Oracle Database class or course? Need to get up and going on Oracle Database really fast, and really easily? Here’s my advice!

Read More
REST APIs and TABLE INSERTs: the Definitive Guide for Oracle
ORDS

REST APIs and TABLE INSERTs: the Definitive Guide for Oracle

REST APIs and TABLE INSERTs, everything you need. Bonus: we’ll build a REST API to GET the data, with support for CLOB/JSON, links, and exception handling!

Read More
SQL Developer

Updated December 1, 2020 – after some reports from folks having issues on Big Sur, I added some additional details around troubleshooting.  I have ran into a few issues getting SQL Developer version X.Y.Z on my Mac Mini, and I’ve seen a few questions online today now that Big Sur is available. This usually happens as folks get new hardware or as updates are applied to their machines…something quits working. It usually boils down to…

SQL Developer

The SQL Developer team has been steadily adding features tailored to the DBA since the version 3.0 release. This steady march continues with version 4.1. The DBA feature I want to talk about today is the Instance Viewer. To open it, you’ll need: SQL Developer 4.1 JDK 8 – this screen uses Java FX, and it’s designed with Java 8 a very high privileged account – I’m using SYS b/c I can Pst! We updated…

SQL Developer

We have a new version of SQL Developer Data Modeler for you to check out – version 4.1. It’s an ‘EA’ – or early adopter. So, no official support – all feedback should be provided via the OTN Forum/Community. It requires Java 8. If you see a message about not supporting Java 8 – ignore that and just click ‘OK.’ You can read all about it and download it here. I’ll be blogging about the…

SQL Developer

Question: I can’t figure out how to make a column list align like this (underscore = space): _SELECT_column1 ______,_column2 ______,_column3 ______,_column4 ___FROM_table The closest result that the formatter produces is: _SELECT_column1, __column2, __column3, __column4 ___FROM table where all column names start at text position 3… My answer isn’t going to be perfect, but it’s going to get the questioner, and you, very close to what you’re looking for. Set These Formatter Preferences One comma per…

SQL Developer

Remember, you only see the error messages in the log AFTER a compile. If you want to see the list of errors at any time, simply click on the ‘Errors’ page, or try compiling your program again. While we’re on this page, there’s lots and lots of cool things you can fiddle with here. For example, ‘SELECTED TEXT.’ And of course you can use this preferences page to setup a more classic ‘green-screen coding’ display..…

SQL Developer

Oracle SQL Developer is a tool. My general rule for using tools boils down to – if the tool is making it harder to do the job you’re using it for, you’re either ‘doing it wrong’ or you have the wrong tool. Sorry for the long setup, but I had someone approach me at the DOAG conference in Nuremberg this week with the following request: I cannot really use your tool to work with my…

SQL Developer

Updated 17 April, 2020: This feature now supports AutoReplace Oracle Docs just underwent a facelift, and I was testing to make sure that the code insight feature in SQL Developer was still able to pick out our code samples. Good news, it still works! But, I was getting distracted by a bit of code that LOOKED like it was DOCS related, yet wasn’t… So if it’s not coming from the docs, where is it coming…

SQL Developer

My work machine is a Dell laptop running Windows 7. My home machine is a MacBook Air running OS X Yosemite. 98% (made up number) of the posts on this site were written using my Windows machine. But now that I’ve discovered that my SnagIt license is also valid on my Mac, I’m trying to do more writing there. It’s also a good way to see how the other 10% of our users work, live,…

SQL Developer

It’s so much more fun to watch users demo and brag about your software than it is to get up and do it yourself. For one thing, it means a lot more coming from real people than it does coming from someone PAID to talk it up. Today, about 40 of us in Raleigh/Durham watched David Mann [Twitter] demonstrate lots of fancy SQL Developer reports at the East Coast Oracle Conference. Before he started, he…

SQL Developer

Oracle ACE Director, BI/data/all things cool and extraordinaire, Stewart Bryson had a bit of a complaint about our favorite tool today. He wants Explain Plans in SQL Developer to show the same notes you can see in SQL*Plus… @thatjeffsmith See… no execution… and the notes. With one little statement. pic.twitter.com/w3GYkIPaDY— Stewart Bryson (@stewartbryson) November 4, 2014 So how do you see the Explain Plan notes in SQL Developer? The database writes that plan meta data…