How to import data from Excel or CSV to a NEW table in your Oracle database using Oracle SQL Developer.
Create AND load the table with one wizard.
Oracle SQL Developer is at its heart, an Interactive Development Environment (IDE.) So it comes with the territory that developers should expect to be able to write good code quickly. One of the many code ‘helpers’ that a good IDE will provide is a Formatter. Formatters, or code beautifiers as they’re also known, take poorly formatted text and make them readable again. This generally comes down to good management of whitespace. Let’s look at a…
Our stored procedures often capture information and store that data as a string or number. But sometimes we need to process more than just a single value. PL/SQL allows you to do this via collections. Now, if you’re looking for help getting started with collections, I would start with Using PL/SQL Collections and Records Oracle Docs The PL/SQL Guru, Steven Feuerstein Once you have a program working, and you want to know what your data…
There’s nothing worse than the ‘white screen of panic.’ You’re faced with the prospect of actually writing some code from scratch. Or even worse, you’re doing a presentation or demo, and everyone gets to see what a horrible typist you are. Yes, this is about Snippets, and Snippets are cool. But if you’re a keyboard person, then you’re gonna like SQL Templates even better. Go read this and come back. -TJS 3/13/15 Yes, you could…
One of the great benefits to having an application developed on the Java platform is the ability to run it on many different operating systems. While Windows may still be the corporate standard in more shops than not, geeks worldwide know that Apple’s hardware and OS (OS X) are ‘superior.’ With yesterday’s release of Mountain Lion (10.8) I figured this was a good time to do a quick write-up on how to get started with…
Looking at data can get tedious. Your eyes start to hurt. Your mind starts to wander. You start humming the theme song to The A-Team. Wouldn’t it be nice if the data you started your day with could be jazzed up a bit? We’ve seen in an earlier post how you can use gauges and hyperlinks in your queries and grids. But maybe you didn’t realize that just plain jane HTML tags would also work.…
This drove me nuts for a few minutes, so I figure you might need help too. That probably explains why you had to Google ‘Block Select’ and wound up here. Here is what you want: There’s No Trick, But You Do Have to Enable It The default behavior is to do a normal ‘wrapping’ selection of text. You can disable this under the Edit menu. Selecting Text In Action On a newer version of SQL…
I know, who has errors in their code? I don’t have errors because I don’t write code. But for the rest of you, it’s possible you have inherited someone else’s problem. And that problem might be an invalid VIEW. You can tell your view has a problem because of the big, sad, red X Oracle stores these errors in a data dictionary view, ALL_ERRORS. You just need to query them. Or if you’re in SQL*Plus…
Oracle SQL Developer by default automatically opens the object editor when you click on an object in your connection tree or schema browser. For most folks this is very convenient. But if you are selecting objects to drag them to a model or to the worksheet, this can get annoying as the focus of the screen changes when you don’t want it to. The other scenario this feature might disrupt more than delight is when…
You have data and lots of it. Some of this data includes images. You store them in your Oracle tables as Binary Large Objects (BLOBs.) You build reports using Oracle SQL Developer. Now you want to make those images in your tables available to your reports, and more importantly, to the end users reading said reports. You can do it! Earlier this year we walked through how to work with BLOBs in Oracle SQL Developer.…