Some of you are real fast typers, and don’t need this type of help. However, some of you, no matter how fast you can type, have to deal with column names that are long, hard to spell, and to just work with in general. So …
Mandatory SQLDev Tip: Filter Your History
It’s Friday! Let’s be honest though – you’ve not accomplished much this week. Monday was a holiday, emails have stacked up, lots of your co-workers are on vacation. So how can we rescue this losing scenario and turn it into a major victory? This trick …
If you only get one SQL Developer ‘trick,’ make sure it’s this one.
I had a fun conversation with @tmuth today: I attempted to distill my entire tips & tricks ‘sermon’ down to a single suggestion. For productivity, I suggest every user get comfortable with Document Tab Groups. So if you want to work on a stored procedure …
Trick: ‘Pasting’ SQL Developer Exports to an Outlook Message as an HTML Table
You have some data. You want to email it to someone. You don’t want them to have to open an attachment. You want it to be in an HTML-Tabl’ish delivery device. In SQL Developer, write your query. Export to HTML > File. Open Outlook. Start …
SQL Developer: Describe versus Ctrl+Click to Open Database Objects
In yesterday’s post I talked about you could use SQL Developer’s Describe (SHIFT+F4) to open a PL/SQL Package at your cursor. If you actually try to describe the package as you see it in the above screenshot, you’ll get an error: I neglected to say …
Copying & Pasting Rows Between Grids in SQL Developer
Apologies for slacking on the blogging front here lately. Still mentally hung over from Open World, and lots of things going on behind the scenes here in Oracle-land. Whilst (love that word) blogging is part of my job, it’s not the ONLY part of my …
Using DEBUG Mode in Oracle SQL Developer to Log SQL
Curious how we’re getting the data you see in SQL Developer when you click on something? While many of the dialogs provide a ‘SQL’ panel that shows you the SQL ABOUT to be generated, I’d rather see the SQL AS it’s executed. True, you could …
Formatting Query Results to CSV in Oracle SQL Developer
You want to run a query or two against an Oracle database. You want to get the data back into a user-friendly and consumable format, such as a comma separated values file. You can do this in SQL Developer, VERY easily. You can watch the …
SQLDev Trick: SHIFT+Hover to Peek Into a Stored Proc
I’m poking around an unfamiliar schema or environment. I’m not sure what these procedures do. I could open them, but I’m lazy and I don’t want the tool to open another document/window. The ‘mystery’ code: These programs are self-documenting as they have the most awesome …