A follower reached out to me late yesterday with this request: And the answer is yes, we can pretty much get there. I’ve noticed a few things by looking at his hand-formatted code on the bottom section. He prefers: everything lowercase right-aligned keywords no line breaks for the sub query ()’s no line breaks after SELECT/FROM/WHERE keywords So let’s go tell the formatter to follow these same rules. Note that all other formatter preferences are…
I’m always a bit surprised when I find a SQL Developer user who does NOT know about the Instance Viewer! Of course you loyal readers know all about it. But you’re busy – you don’t have time to tell your friends. So just send them this video, and I’ll tell them about it. In a nutshell: it’s a performance dashboard in SQL Developer. It will show you what’s happening in your database, all in one…
I’ll show you 3 cool tips and tricks for working with PL/SQL in SQL Developer…in under 7 minutes! In-code navigation – click into where your objects are declared Test Query – see if your SQL is gonna work BEFORE you compile it Using the Code Outline For those that can’t do video, basically you can Ctrl-Mouse-Hover Navigate ANYWHERE Not just on tables, but also on local variables. Right-Click to Test a Query Open and Use…
We recently (18.2) added a new way to generate execution plans in SQL Developer – we generate a call to DBMS_XPLAN for the SQL ID at your cursor position. DBMS_XPLAN is a package, and one of it’s procedures is ‘DISPLAY_CURSOR’: This table function displays the explain plan of any cursor loaded in the cursor cache. In addition to the explain plan, various plan statistics (such as. I/O, memory and timing) can be reported (based on…
I have some code… 1090711125680ecd2452fbc_000003 I can guess that GIVE_RAISES is a procedure of some kind. But now I want to open it, or ‘go to it’ or ‘step into it.’ And I want to do so without having to pick up my mouse. So I could tell you about the Ctrl+Click trick, but that’s all mouse. So what’s a child of the 80’s to do? Define a keyboard shortcut for ‘Open Declaration’ and then…
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…
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 – an Excel file is basically a zipped set of XML files, and this will always…
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 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 read vs watch/listen – I have these two posts: Import from Excel to a New…
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…
