ThatJeffSmith

Tag: sqldev

5 SQLDev Features I’m Thankful For

I hope this post isn’t too cheesy. But it’s Turkey-week here in the USA, and the theme demands that homage be paid. So here are 5 features in Oracle SQL Developer that I use all the time, and am truly thankful for. They help me conserve energy, AND they make my job easier. I want […]

Similar Posts by Subject Areas: , ,

Click vs Type…Again.

This might sound preachy, but it’s mostly not intentional, mostly. You might really enjoy the flexibility of the PL/SQL APIs the database provides for things like Resource management, the Scheduler, Data Pump. You might even have memorized the PL/SQL function/proc names and arguments required to create a job, or change up a resource. But do […]

Similar Posts by Subject Areas: , , ,

Object Search in SQLcl?

I’m always looking for things. I love the ALT+G trick in SQL Developer. But what about the command-line? One of the really nice things about SQLcl is that if you can’t do what you want with the available commands, you can just build your own. That’s especially true now that we have JavaScript support. But […]

Similar Posts by Subject Areas: , , ,

Keyboard Shortcuts Cheat Sheet

Remember back when Corel first released WordPerfect? Remember how it had like a bazillion keyboard shortcuts, and you needed help remembering them all? No? You probably also don’t remember a world sans e-mail and smart phones either. Oh well. Anyways, we have lots of keyboard shortcuts in SQL Developer and a few in SQLcl. You […]

Similar Posts by Subject Areas: , ,

SQL Developer and RAC

Yeah, we support RAC. Note, we did fix quite a few RAC related bugs in the 4.1.1 update. These screenshots were taken with version 4.1.2. When you want to look at historical data in ASH or AWR, you’ll have to specify the Instance number to pull the report from. And the report… Or if you […]

Similar Posts by Subject Areas: , ,

SET PAUSE ON

This has been around for a loooooong time. But after a short chat with @oraclebase AKA Tim Hall yesterday, I thought I’d make sure we’re doing things right in the SQLDev tooling. Tim uses it to make very nice, short, and sweet video demonstrations on his YouTube Channel. I highly recommend it. Anyways, back to […]

Similar Posts by Subject Areas: , , , ,

Just another GIF: Debugging PL/SQL

Start a debug session…step over some code…look at a variable…run to a breakpoint…investigate the data in a PL/SQL table…step into another program…check out the callstack. Just another day in animated GIFs and showing you what SQL Developer is capable of. If you’re curious or want more info, hit the ‘debug’ link at the end of […]

Similar Posts by Subject Areas: , , ,

More on XML Extensions in Oracle SQL Developer

I’ve written a few posts on this subject… Intro to Extensions Adding Synonym Support with Extensions Adding an Error page for Views with an Extension Also, there’s two VERY nice resources for you that I recommend: My predecessor Sue Harper talks extensions in Oracle Magazine Mike Smithers has an exhaustive blog post on adding context […]

Similar Posts by Subject Areas: , , ,

The SQL*Plus Stuff You Like and Love Lives On in SQLcl

When demonstrating SQLcl, I get the feeling that half of the audience is filled with dread. Yes, they love everything that I’m showing them. But deep, deep down they are scared that the things they personally liked in SQL*Plus are going away. I’m here today to alleviate those concerns. Instead of asking you to just […]

Similar Posts by Subject Areas: , ,

Finding Columns

One of the most viewed threads over the last 30 days in our OTN Community for SQL Developer is a post from 2010. 2010. Wow, I says to myself – that’s gotta be interesting to a lot of folks, what is it? It’s a question on how to find table or view columns. And the […]

Similar Posts by Subject Areas: , , , ,

Four Minute Video Tip: Configuring SQL Developer for the First Time

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 […]

Similar Posts by Subject Areas: , , ,

How to Reset Your SQL Developer Preferences/Settings

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 […]

Similar Posts by Subject Areas: , ,

Job Frequency with DBMS_SCHEDULER and SQL Developer

I was remarking to someone this morning how easy I thought it was to setup a job, say on the first and third Wednesday of the month. The flexibility of DBMS_SCHEDULER, even without taking into account the power of schedules, is really powerful. We have a scheduler wizard that puts a graphical user interface onto […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , ,