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

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 PAUSE. SET PAUSE ON [DOCS] in sql*plus allows a script to ‘pause’ until you hit ‘ENTER’ for it to continue.…

SQL Developer

A question came up on the oracle-l… I am working in SQL developer 4.0. I am comparing my acceptance version of a schema to my production version of the same schema. We did some ‘clean-up’ of old tables and views in acceptance. We want to apply the same changes to production, when we go to prod. How do I tell SQL D to produce a ‘drop’ statement when running a diff and doing the compare?…

SQL Developer

For those Windows users out there who want both a BASH shell AND a really cool command line interface to Oracle Database – I have good news! We updated SQLcl yesterday to include support for CYGWIN. I have Cygwin64 and Windows 7. We also added a new command, SHOW TNS. This will help you figure out how and where we’re finding your TNSNAMES* files. 175207885167ecd97d2e128_000002 So we’ll look in your home directory, your TNS_ADMIN space,…

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 menus But. None of these resources detail the object node names for the different types of editors you might want…

Personal Tech

Kellyn (@dbakevlar!) and I have given a couple of talks at the RMOUG Training Days conference about social media, and why Oracle techies should care. We thought it might be nice to focus the talk a bit more and offer it up as a keynote presentation. The crazy folks at East Coast Oracle Users Conference agreed, and we gave it yesterday. People liked it. Even the people serving the food and taking away the dirty…

General

It’s that time of year again: planning for our biggest customer and user event, Oracle Open World. I recently shared some advice for getting the most out of your conference experience, here’s a 2 minute video: One of the bits there I suggested was to mark one or two sessions a day that you might want to attend. Well, since you’re here, I’m assuming you might find the stuff our team is doing appealing. Note…

SQL Developer

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 line numbers open on SINGLE CLICK! connection folders query results new grids

General

These are just my opinions, and I don’t speak on behalf of my employer. On the Facebookers this morning, noticed one of my friends was contemplating coming out to San Francisco this year to join approximately 50,000 other Oracle and Java-heads for Java One and Oracle Open World. I’m not going to try to sell you on this event – the location alone should be enough to get most of you excited. San Francisco is…