ThatJeffSmith

Category: Database Stuff

Oracle SQL Developer: Code on Demand

I’ve recently spent a few hours debugging some user defined reports. A post on how to add trace/disconnect context menus to a session report required that I figure out what session my worksheet was running under. The code was easy… …but I’m lazy. So this: The Setup Open your preferences and go to the SQL […]

Non-English Character Display in Oracle SQL Developer

I get a variation on this question at least once a week, if not more frequently. I’m from Israel, and the language on the databases is Hebrew. When I use the old and deprecated SQL*Plus (windows rich client) I can see the hebrew clearly, when I use the latest SQL Developer, I get gibberish. This […]

SQL Developer Quick Tip: Running Scripts off the Web

Did you know you can run SQL*Plus type scripts directly from the web? Now, I’m going to assume the following: You know, trust, and have tested these scripts You don’t assume that everything on the Internet is true That Tim doesn’t think I’m trying to suck up to him, much So, in a SQL Worksheet, […]

Oracle SQL Developer Code Insight Syntax Examples

There really are times your tool is smarter than you are. Thank you #SQLDev Code Insight for listing syntax examples. @thatjeffsmith — Amy Caldwell (@amyccaldwell) August 7, 2014 In fairness to Amy, I don’t think SQL Developer is ‘smarter.’ I think it just has faster access to the Oracle Docs than she does. And SQL […]

SQL Developer at Oracle Open World 2014

Oracle Open World is just around the corner. Every year, tens of thousands of Oracle geeks gather in San Francisco for a week for learning, networking, and more than a little bit of fun and socializing. If you’re going to be there, here’s what you need to know about your favorite development tools team Fun […]

Oracle SQL Developer Around the World

Oracle SQL Developer is being used around the world. I see evidence of this in Indonesian tweets, OTN forum questions written in Spanish, talking to people at the larger tech conferences, and looking at our website Google Analytics. For just this site, here’s where people have visited from in 2014: If I look at the […]

Viewing Complex Types in Oracle SQL Developer Data Modeler

Instead of having a column of type VARCHAR2 for a ‘Country,’ you might want to create an COUNTRIES type. Said COUNTRY would have an ID, NAME, and LOCATION. To make things even more fun, LOCATION would also be a custom type of LOCATIONS, having even more attributes/columns. To model these from scratch, you would build […]

3 More Oracle SQL Developer Bloggers

I’m on vacation this week – so in order to keep you folks entertained, I thought I would spotlight a few of our developers who also blog. Kris Rice Kris is one of the two original developers of SQL Developer. He’s also my boss, but don’t blame him for me. Lately, he’s been into all […]

Clearing the Script Output Buffer in Oracle SQL Developer

Quick Question: Is there a way in SQL Developer to have the DBMS Output window clear when you execute a block? Quick Answer: CLEAR SCREEN [Oracle Docs] SQL Developer supports many, and soon to be ALL, SQL*Plus commands. CLEAR is one of them. So just add this to the top of your script. When you […]

Oracle Database 12c SQL Translation Framework: Fixing Bad SQL

One of the new Database 12c features is the SQL Translation Framework. Developed primarily to help customer migrate their 3rd party applications and databases to the Oracle stack, it also offers application DBAs an opportunity to substitute poorly performing SQL with their own custom SQL – without changing the application itself! Do I have your […]

My Favorite SQL Developer Data Modeler Features

I’m doing a talk on this very subject next week at ODTUG’s KScope14 conference, and I’ll put up the slides on Slideshare after the show, but I wanted to give a quick shout-out to the things you COULD Be using today to get the most out of your models and design experience. Search SubViews Reports […]

Configuring Memory Usage in Oracle SQL Developer

Sometimes you need more memory. Here’s an example: you want to model a database that has 1500 tables in it. What would that even look like? If you zoom out far enough… Now, ‘large’ is a subjective term. But lets put it this way – if you’re dealing with more than several hundred tables or […]