I’m new to Oracle, and I need a database…help!
Database Stuff

I’m new to Oracle, and I need a database…help!

Taking an Oracle Database class or course? Need to get up and going on Oracle Database really fast, and really easily? Here’s my advice!

Read More
REST APIs and TABLE INSERTs: the Definitive Guide for Oracle
ORDS

REST APIs and TABLE INSERTs: the Definitive Guide for Oracle

REST APIs and TABLE INSERTs, everything you need. Bonus: we’ll build a REST API to GET the data, with support for CLOB/JSON, links, and exception handling!

Read More
SQL Developer

We already know how easy it is to view images and plain text with the BLOB editor, yes? But what if I have in my column a bunch of PDFs stored? I want to see that stuff without having to save the file, finding it, and then opening it. Why can’t I just automatically open it directly from the database? Well, it seems you can. Here’s how. External Editors Step 1: Make sure you have…

SQL Developer

Do you find yourself always scrolling and scrolling and scrolling to get to the column you want to see when looking at a table or view’s data? Don’t do that! Instead, just right-click on the column headers, select ‘Columns’, and reorder as desired. Then move up the columns you want to see first… This will only change how the data is displayed for you, and SQL Developer will remember this ordering until you ‘Delete Persisted…

SQL Developer

I’ve been running version 4 for so long, that I have trouble remembering if some features are new to version 4. Well, here’s a simple feature that IS new to version 4 that I think our PL/SQL friends will appreciate. Say that you’re looking at a PACKAGE SPEC member, like a FUNCTION, and I want to ‘jump’ to the BODY implementation of said FUNCTION. Or vice versa, I’m in the BODY and I want to…

SQL Developer

My alternate title for this post was How to get the DBAs’ attention with lots and lots of connections in her database. But I decided to go with substance over style instead. Anyways, let’s talk about connections in SQL Developer for a bit – you know you need the refresher! By default, connecting to a database in SQL Developer opens 2 connections Main connection Insight connection for figuring out what text is a table and…

SQL Developer

So you’re minding your own business, doing your work, and you click in your favorite Oracle Database IDE. Do you get what you asked for? No! Instead, you are rewarded for your troubles with this puzzling and frustrating message. Abort? Try again? Busy? The Long Answer When you connect to a database in SQL Developer you are actually making two connections. We use one connection to run background queries in the the worksheet. This makes…

SQL Developer

Another busy, crazy, awesome week is behind us. I’m going to call it a success, but before I completely file it away, I wanted to share a few quick thoughts, and say thanks to a few people for their continued support. Sunday SQL Developer Golden Gate Fun Run We had about 20 people show up – including a few crazies that ran up from the Hilton and back – and the weather was amazing. Yury…

SQL Developer

Someone told me today that they can’t log a support request with my Oracle Support for SQL Developer. To which I replied with, ‘Oh yes you can.” To which they replied with, ‘But I do not see it in the dropdown of my products.” To which I replied with, ‘Oh, that…’ But seriously, Yes, You CAN Log SRs on SQL Developer with MOS You just have to look for it. Voila, now enter your stuff.…

Expired

EA1 dropped in July. Now here we are a little more than a week before Oracle Open World and we are making Early Adopter 2 of Oracle SQL Developer version 4 available for you to download and provide feedback. There’s two big things you need to know about: About 500 bug fixes Support for ADDM/AWR/ASH Bug Fixes Thank you, thank you, thank you for your feedback on the Forums, Twitter, our blogs, and any other…

SQL Developer

In previous versions of Oracle SQL Developer, if you start typing in the Data tab’s filter dialog on a Table Editor, SQL Developer would make suggestions for you. A few folks have asked that we not be so aggressive with the ‘help’ here. And I wholeheartedly agree. So in version 4… If You Want Help, Ask For It! So what’s the magic key sequence? It’s the same as in the worksheet when activating the Code…

SQL Developer

You may not spend a lot of time creating tables in your database, but if you are performing that task, you don’t want your tool to slow you down. And while many of you may design your tables in a modeling solution or even code them by hand in a worksheet, there are still some of you out there that are using our Create and Alter dialogs. And that’s what I’m here to talk about…