SQL tuning can be fun. The database gives us MANY things to help with this. There is even a nice set of views that contain everything we need to know about our SQL and their exectution plans. And, we have a really cool PL/SQL package, DBMS_XPLAN for generating reports on our troublesome queries. The not-fun part, is going from a …
Oracle SQL Developer version 18.2 – Faster!
So two areas of major performance improvements in Oracle SQL Developer version 18.2: Importing from Excel Using the Query Builder Importing from CSV was generally always pretty fast. Working with Excel consumes a lot of memory, and it took a lot of time to load an Excel file to be imported. Well, it still uses a lot of memory – …
When No Data Found: Our New Podcast
I say ‘our’ because I’m doing this with Scott Spendolini, an Oracle ACE Director in the APEX community. We wanted a podcast of interest to Oracle Database developers. We like each other. We have great stories. Bad/good things happen when we get together. So, we came up with this… We want to post on a regular basis, as fast as …
Version 18.2 Is Now Available (SQLDev, SQLcl, DataModeler, ORDS)
It’s that time of year again, we have just released updates to all of our tools! Downloads Here: Oracle SQL Developer Oracle SQLcl SQL Developer Data Modeler REST Data Services (ORDS) Let’s Talk about SQL Developer It’s a minor release, no new major features have been introduced. But, we fixed a TON of bugs. And more than several of those …
VIDEO: Importing from Excel Table
It’s a bit long at 17 minutes, but I go through the process of: creating a new table based on an Excel/CSV defining the columns checking the column names checking the column definintions is the column wide enough? defining DATEs running the export fixing errors saving the scenario so you can run it on demand Remember, if you prefer to …
Where Desktop and Web Collide – Sharing Data Modeler Diagrams
You might have heard we now have a new SQL Developer in the family: SQL Developer Web. If that’s news to you, here’s a quick video recap: Hopefully you noticed that one of the main features of SQL Developer Web (and SQL Developer Desktop!) is data modeling. We were thinking: wouldn’t it be nice if could pull up a diagram …
KScope18 Sunday Symposium Slides
This past week we were at KScope – the premier all things Oracle conference here in the United States. The Database team were very well represented, and we did 15 minute lighting talks. Maria has already shared her slides/talks here – they were AWESOME! Here are mine. Let’s Go Shopping It’s all about the Cart. Oracle SQL Developer: The Cart …
Easier Preferences…Digging
We have a LOT of application preferences. And users have a funny habit of asking us to add MORE to every release. So, it’s great that we make it very easy to customize their SQL Developer experience via a few clicks and toggles. But, it’s kind of hard to find the RIGHT switch when you want to go change something. …
New Oracle VirtualBox Appliance Available
You can download it here. With this VirtualBox Appliance, you can spin up a virtual machine that already has Oracle Database, Application Express, REST Data Services, SQL Developer, SQLcl, and more…all running for you, automatically. The APEX team has also given you a TON of new APEX 18.1 focused labs. Including one for using REST Enabled SQL from ORDS. How …
SQL Developer Reporting: Video Demo & Slides
As a feature: Been there forever On the desktop by default 80% of you aren’t using it I think it’s a feature that can really turbo charge your experience with the database and SQL Developer – so I did a 10 minute talk on the subject. So if you’re curious about what you might be missing, here you go! And …