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
General

It’s amazing how the ‘little things’ can often make the biggest impact on the end user experience. Example: when you ask your software to do something, you want a visual indicator or feedback dialog to let you know how that request is being processed. Imagine submitting a order request on your favorite shopping website and not getting a response back. Did they accept my order? Will I get my book? Did they take my money?…

SQL Developer

In case you’re curious, I’m calling yesterday ‘Day 0’ as it was spent doing trivial things like getting email setup. Today I feel like was closer to a real day of work. I spent a few hours this afternoon going over some request from the users. One stuck out pretty prominently – ‘Keep-alive functionality’ The basic gist is at some point your connection to the database is terminated due to an inactive connection. This can…

Database Stuff

Since I announced my new job at Oracle, I’ve had more than a few friends and associates approach me about databases. They’ve always wondered just what it is that I talk about all the time, or perhaps they want to get their feet wet and want to know more about data in general. I think this is fairly normal and expected, especially as just about everyone has some sort of interaction with a database. As…

General

The good folks at Oracle, namely @krisrice, approached me this past Summer with an offer I found myself unable to refuse. The short version would be something like, ‘Hey, come join our SQL Developer team.’ So next week, I will start the next chapter of my professional life as the Product Manager for Oracle’s primary database development tool. This is a very exciting moment for me. I remember first seeing Oracle in my senior year…

General

I loved my job at Quest Software. I loved the people, the technology, and usually our customers! I got paid to talk and think and write. But that chapter of my life closed last week. There were so many friends and close acquaintances I made over the last decade that it was impossible for me to reach out to all of them. So I hope if you are reading this now, you’ll know how grateful…

General

It’s still me! That dude that spends a lot of time talking technology, databases, software, and the occasional bad joke. I screwed up. @BrentO told me 2 years ago that it’s better to use your real name on Twitter. And I didn’t listen to him. So now I get to take my medicine and go switch everything over to my new account – ThatJeffSmith. It’s not a coincidence that my new Twitter handle matches the…

Database Stuff

A Toad user posed this question today: Is there a way to move a (marked) TABLE mytable123 from Tablespace AAA and Schema BBB to another Tablespace USERS and Schema MYSCH? Let’s tackle the 2nd and easiest part first! Moving a table or partition to a new tablespace is pretty straightforward: ALTER TABLE table_name MOVE TABLESPACE tablespace_name; The ALTER TABLE MOVE clause is documented and diagrammed in the Oracle Docs. However, the user ALSO wants to…

General

Two quick apologies – 1)This post may ramble a bit more than usual, and B)It’s not my intent to insult or degrade any of the folks I help online. This blog serves as my conscience and my therapist, and I’m not in the mood to cover technical topics today. First off, you may wonder what I mean by ‘user.’ Surely that is synonymous with the term ‘customer?’ You might be surprised how many people actually…

Toad® Stuff (Retired)

Toad used to just be a simple freeware software program. Oracle developers could download it and use it in a matter of a few minutes. Today, it’s an entire brand at Quest Software – and does everything from Oracle to Apache Hadoop and surely isn’t limited to just developers anymore. This week my friend and co-worker Steven launched a new contest where Toad users can compete for prizes and money by taking a series of…

Personal Tech

I love Lisa Barone. She helps me understand things like Search Engine Optimization (SEO). So when she posted today an article called ’10 Things EVERYONE Should Know about SEO In 2011′, I read it right away. Please take a second now to read it, as I’m going to help you fix problem #7. 7. [Click Here] is never suitable anchor text Ok, so we should never use the words ‘Click Here’ to anchor tags, like…