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 introduced the Instance Viewer in v4.1. We show you in real time what’s happening in your database. To get there, open your DBA panel. Connect. Then go to the Database Status node. Storage bits are interesting, but maybe you’re more excited about the specific workload. So in version 4.2, we’ve added a Top SQL panel to the screen. It auto-refreshes every few seconds, and you can sort it by several different performance metrics. If…

SQL Developer

For some reason I procrastinated setting up my video software on my new work machine. Big mistake. I put together this animated GIF to show some new things in version 4.2: Updated formatter – better support for ANSI joins Opening objects referenced in your execution plans Inserting Hints Not new but underutilized: how to compare plans/AutoTraces One Last Thing… …don’t forget about the HotSpot feature we added in v4.1.

SQL Developer

Someone said we should make the view source searchable, and that we should show any errors on a view. Actually, it might have been a few dozen of you. A reader reminded me that we actually implemented this in v4.2. Code Outline I’ll go into more depth here next week when I’m back from Open World, but we’re working on building a new advanced Code Outline. Right click in your editor to open it. It’s…

SQL Developer

In both v4.1.5 and v4.2, you can now select objects from your database tree, and drag them to another connection to have them copied. The source can be: a MySQL, DB2, SQL Server, Sybase, Terradata, or other 3rd party supported RDBMS an Oracle Database The destination can be: an on-premise Oracle Databaes an Oracle Database running in the Oracle Cloud You have a few options: For tables, we’ll also grab it’s indexes, triggers, and constraints.…

SQL Developer

Oracle SQL Developer Command Line (SQLcl) is the full name for what we’ve been calling, SQLcl. Have you seen the video? It’s only 8 minutes and will catch you up on just what SQLcl is. Anyways, there’s a ‘new’ command called SCRIPT that I want to show you today. I say ‘new’ because we added this in October of 2015. Stealing from @krisrice… This new command can radically change things you can do in the…

SQL Developer

In SQL Developer we have color coded connections. This was added, not because we like Christmas trees and all the pretty lights, but because sometimes you need a reminder of what database you’re on. So you don’t TRUNCATE stuff, accidentally. Visual cues won’t prevent all mistakes, but they sure help. With SQLcl, you have the abilty to setup your SQL prompt with custom text and colors. This works better if you have a decent terminal.…

SQL Developer

I have an UMLAUT table. Pretty simple really… 194027311967ec9eb91a4d5_000008 Looks great in SQLDev, but not so much in SQLcl… Everything is UNICODE by default in Java applications. It’s converted to Unicode coming in and going out… [docs] This is a HUGE advantage in the Java world. We don’t have to do anything special when it comes to supporting Unicode. So what’s happening above? Windows CMD by default isn’t setup to use a Unicode code page.…

Database Stuff

If there is a Madonna or Prince in the Oracle Database world, that would be Tom. You know, people that are known solely by their first name. Of course there’s also Larry, but from a pure database tech perspective, Tom has satiated the curiosity of developers and DBAs for the past couple of decades. If you were stuck with a technical challenge, or just needed help settling a bar bet – what’s better, count(*) or…