Ok that title has a TON of buzz and marketing words in it. But, we have the Oracle Cloud. And available there is a service where we take care of your database for you – Autonomous. We make sure it’s up, and that it’s fast. We have 1 autonomous cloud service today and will have and second one coming SOON. These services come with an S3 compatible Object Store OSS (Oracle Object Storage, complete with…
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 SQL statement to the SQL_ID. Now, SQL Developer has for a few releases made it…
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 we can record and Scott can produce them. We’ll be talking about news events in…
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 were reported on the FORUMS. Thanks again to everyone in the community who pitches in…
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 you built in SQL Developer Web into the Desktop copy of SQL Developer or SQL…
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 from Jeff Smith Social Media – Why a Database Person Should Care Plus 3 quick…
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 to launch SQL Developer In the terminal/console, run ‘sqldeveloper’ That’ll launch 18.1 for you. Create…
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 for folks that would like the slides: Oracle SQL Developer Reports from Jeff Smith
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, you get to see me think in real time as I cocktail-napkin-style ‘design’ my table.…
Not able to make my Tips & Tricks talk at the Great Lakes Oracle User Group conference this week? Don’t have the 50 minutes to watch my recorded YouTube version? Can you spare 90 seconds? You don’t even need to turn the sound on. Just watch this GIF. To recap: ALT+G to do a search Use Doc Tab Groups to see multiple things at once Ctrl+Space to auto-complete Filter grids with WHERE clause predicates drag…
