Below you'll find a list of all posts that have been tagged as “preferences”
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 …
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. …
In SQL Developer you can configure how you want things to work for your session. How DATES should appear. If numbers should use a ‘.’ or a ‘,’ to indicate group separators and decimal points. We try to guess these things based on your local machine settings, but you can of course override them. But let’s see what happens when …
As much as I like the Export Comments, or hints… SELECT /*insert*/ * FROM hr.employees or the less intrusive SET SQLFORMAT insert… sometimes you just NEED to use the Export feature tied to a grid. Did you know you can pre-select the defaults? For example, if 9x out of 10, you send the output directly to the Worksheet, and if …
I sometimes get a double-take when I do a blog post or tweet or show a picture of SQL Developer running on my Mac. My Macbook is my personal machine: I don’t normally do live-demo’s on it, but I almost always do my blog posts and screenshots from there. For official webcast stuff and conferences, it’s the old workhorse Win7 …
You’ve just installed a new copy of SQL Developer. Here are some things you might want to change in the preferences. Notes: I said ‘fixed field’ – I meant FIXED WIDTH fonts, duh If you think you’re hearing Foreigner’s Feels Like The First Time, you’re wrong Some of the tips in blog format: fonts zebra line numbers open on SINGLE …
We store the application settings PER user. So find where your OS stores files for your OS user. These settings are stored HERE on Windows (…AppData\Roaming\SQL Developer): They are stored HERE on Macs and *NIX ($HOME\.sqldeveloper): Find the directory that corresponds with the version you are running and having problems with. Rename it. Restart SQL Developer – you should be …
Updated Wednesday, July 6, 2016 Setting up a new install of SQL Developer this morning – exciting stuff as we’ll be teasing some v4.1 features at Open World this week – I found myself immediately tweaking the following preferences. Font – we’ve talked about this a few times, but I make it bigger to make it easier to see in …
If you’ve been paying attention, I’m not a huge fan of ‘automatic’ features. I like to use features on-demand. One of the default preferences in the tool is to open an object as soon as you click on it in the connection tree. But as soon as I want to drag an object to a model or to a worksheet, …
I do a lot of live presentations and demonstrations. I’m frequently asked, ‘why does your SQL Developer look that way?’ or ‘How can I make SQL Developer work that way?’ It’s all about the preferences (or options.) So here’s what you can do if you want to be like me. By the way, I can’t really help you if you …