Below you'll find a list of all posts that have been categorized as “SQL Developer”
Someone asked on StackOverflow how to get loading a 1,000,000 records to be faster in SQL Developer. My answer was basically, don’t use SQL Developer to load 1,000,000 records, use SQL*Loader. Now, I also reminded folks that you can USE SQL Developer to build your SQL*Loader scenario. There’s 2 ways actually: Query existing records, export to Loader (Keep Reading this …
Was helping someone on Stackoverflow this morning, and thought you might enjoy seeing this process as well. PROBLEM: You’ve created a schema script, you’ve generated the DDL, and you ran it on your brand-spankin’ new database. Except. Except, you ran that script as SYS, and your schema scripts didn’t have a SCHEMA defined. So you’ve corrupted your SYS schema!!! How …
Things to know: MANY bug fixes The Windows Embedded JDK is now Version 8 update 181 You can have nested connection folders in the main and DBA connection panels Real Time SQL Monitoring reports can be exported to (non-flash) HTML Connections Some of you out there work with MANY databases, and so of course have tons of connections to work …
Why would I use SQLcl over something else? History recap: we introduced a new command-line interface for the Oracle Database in 2016. It’s everything you like about SQL*Plus, and everything you didn’t like about SQL*Plus – fixed. Do you have a minute? Watch this, then take 10 seconds to consider how YOU might use it. Everyday Things, Easier Just in …
Stumbling around on StackOverflow this morning, I came across this person’s HOMEWORK question, and the answer chided them on not using ANSI style JOINs. I’m not going to post the actual SQL here, but if you follow the previous link, it’s there for you to grab and have a go. Something I like to do is take REAL code off …
The question: We have big database with a lot of stuff and I want to use version control (Git) to manage changes. There are a lot of articles how to do it step by step but one piece is missing for me. Is there standard or recommended way for file structure of whole database (data excluded) and how it can …
I was using the Instance Viewer today and ran into the drill down for Storage. Let’s take a closer look at that report. I like this report enough, that I want to be able to run it in SQLcl. SQLcl is a command-line interface, so I’ll have to make a few changes. The links won’t work, boo. Those are easy …
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 …
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 …
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 …