How the Big Boys Do It!

We have a number of VERY large (video on demand) customers.  We've broken our customer-base into 3 categories:

1. Infoprenuers - these are companies who do something and have video, but video is not their primary business.  For example, RunBare.  Their primary business is teaching people how to run in your barefeet.  They do have a video on this topic, along with books and other items.  Another example is BDB Software, which is my (more...)

Remote DML with DBMS_PARALLEL_EXECUTE

A comparison of sucking data into a table over a db link using DBMS_PARALLEL_EXECUTE.

This particular example is based on something I needed to do in the real world, copying data from one database into another over a db link. Datapump is not available to me. Tables in question happen to be partitioned by a date-like number (boo!) hence some of the specific actions in the detail.

I think it’s a good example of (more...)

The Spiritual Programmer

Based on my article in the latest issue of OTech Magazine, I am offering a free teleseminar (by phone or Skype) on how to live a happy, meaningful life in IT.

Programmers have a head start over the rest of humanity in leading happy, meaningful lives. If you have not yet reached complete enlightenment, I encourage you to sign up and invest 30 minutes listening to this call. It might improve your life.

Sharing SQLDeveloper SQL history across several machines with Dropbox

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. A quick tip for keeping a single shared SQL history repository among different installations of SQLDeveloper, for the same user, on distinct computers synchronized with Dropbox.   This seems to be working just fine on Mac OS X and SQLDeveloper 4.0.2 however it's a totally unsupported

Abgeleitete IS NOT NULL Prädikate

Jonathan Lewis weist (im Rahmen einer Quiz-Frage, die sehr schnell ihre Antwort fand) darauf hin, dass der Optimizer implizite IS NOT NULL Prädikate schon seit vielen Releases aus der Join-Bedingung ableiten kann (im Sinne von: wenn ein Join durchgeführt wird, kann die Join-Bedingung keine NULL-Werte enthalten haben).

OTech Magazine Issue 4 – APEX 5 and much more

Well it's the second half of August and this is my first real post for the month. There are two very good reasons for this:

1) We've just completed a major implementation at one of our clients - a tablet based application using APEX, which completely changes the face of a major arm of the business. It's a groundbreaking application with only one peer in the industry - which users are already claiming superiority to (more...)

Demystifying Oracle Unpivot

A couple of years ago I posted a simple example using PIVOT, converting rows to columns with the classic example of figures by months.

Oracle 11g R1 also introduced the UNPIVOT function, allowing columns to be converted into rows.

Problem

I've created an example that lists cities by row, but two attractions as two columns, with pairing attributes describing the reason for the attraction.
create table aus_attractions(id  number, city varchar2(50)
, attraction1 varchar2(50)
, (more...)

Oracle 12C – In-Memory Option Resources

Hi folks,

Introduced as an Option Oracles In-Memory option will change the world of databasing also like SAP HANA does; Since July the release is out but the search for resources and documentation is  poor;

Here some useful links I found.

Non-Oracle Resources

 

Oracle Documentation

Concepts (found a small passage) ...

 

 

just started the list - wiil enhance it - from time to (more...)

Employee or Member Training

Do you have a group of employees or members that you would like to train?  Would you like to make the training available for a limited time only - such as for 2 weeks?  Would you like to have the ability to take the ability to view the training away at your discretion (such as when an employee leaves the company)?  Would you like to know who watched which videos?  For example, did Jim watch (more...)

Wrapping SQL*Plus

One annoying thing from installing Oracle Database 11g on Fedora, was that the up arrows for command history didn’t work. I decided to fix that today after seeing Lutz Hartmann’s article on rlwrap. Unfortunately, the epel (Extra Packages for Enterprise Linux) package he recommended doesn’t run on Fedora 20. You can read my tale of woe, or skip to the .bashrc function that fixed it when I installed only rlwrap.

Attempting it on yum, (more...)

Time to resurrect blogging!

Sorry for staying quiet for some time, but for some good reasons. Some of these reasons will be explained in later posts, but for now I would like to share the story I wrote upon request of Steven Feuerstein, who asked to tell how PL/SQL impacted our life. Here is my story:

-----------------
I started to work with databases already in college, but more from the data modelling/business analysis angle. When I moved to (more...)

Funding = People = New Functionality

Funding Makes a Huge Difference

Once we closed on our series A funding in May, we were able to afford some of the top industry talent to take InteliVideo to the next level.  It's been a very exciting couple of months and it promises to be a very exciting next several years from the looks of it.

SO Many Great Uses

As we've been working with our customers, we continue to see so many impressive (more...)

New issue of OTech Magazine

The summer edition of OTech magazine has just been published – 111 pages packed with information from international Oracle technology experts.

Authors and topics are:

  • Sten Vesterli – The Spiritual Programmer
  • Scott Weseley – APEX 5.0 New Features
  • Patrick Barel – Dear Patrick
  • Emma Groomes & Crystal Walton – KScope 2014
  • Anar Godjaev – How to protect your sensitive data using Oracle Data Vault
  • Debra Lilley – Women in IT Initiative
  • Lonneke Dikmans – (more...)

drop table people

Wenn es bei xkcd einen Strip mit SQL-Queries gibt, muss er hier verlinkt werden - auch wenn's vielleicht eher um ein philosophisches Problem geht.

ADF 12c Courses Now Online 

Once again the ADF PMs have been hard at work to provide us all with great training content. This time in the form of a full online course.

Oracle University has begun the First Global Teach of the Oracle Middleware 12c: Build Rich Client Applications with ADF course online.

This course covers all the useful features of ADF Business Components including  how to build and test reusable business services. After creating the application they drill (more...)

ApacheTomcat: How to sustain planned/unplanned Oracle database downtime & Runtime Load Balancing w UCP

See our brand new white paper  http://bit.ly/1ApSIqr 

★ Database as a Storage (DBaaS) vs. Thick Database

A recent addition to my Oracle PL/SQL library is the book Oracle PL/SQL Performance Tuning Tips & Techniques by Michael Rosenblum and Dr. Paul Dorsey.

I agree with Steven Feuerstein’s review that “if you write PL/SQL or are responsible for tuning the PL/SQL code written by someone else, this book will give you a broader, deeper set of tools with which to achieve PL/SQL success”.

In the foreword of the book, Bryn Llewellyn writes:

The (more...)

The Internet of What?

Gartner has just released another iteration of their classic “Hype Cycles.” They are up to more than 100 different topics now, but one interesting graph is one is the one for Emerging Technologies.

Source: Gartner Hype Cycle for Emerging Technologies 2014

I want to comment on a couple of points from this graph:

  • Internet of Things as peaking – completely agree. Everybody is talking about it but what do we have? An internet-connected smoke alarm.
  • Big (more...)

Book Review: “Write the Perfect Book Proposal”

I’m not in favour of calling books a “must-read”, but if you want to get your own book commercially published, I have to say you must read Write the Perfect Book Proposal: 10 That Sold and Why, 2nd Edition.

The main force of this book is that it explains the publishing industry from the inside: What a publisher is looking for. The authors honestly explain what the publisher will and will not do, and that (more...)

UKOUG Tech 14 in Liverpool

I’ll be going to the UKOUG Tech 14 conference in Liverpool in December to give one of my favorite presentations: “APEX or ADF? From Requirements to Tool Choice”. I’m also leading the Development Tools roundtable, which is always lively at the UKOUG conference. If you want to discuss your options as a developer in the Oracle world, UKOUG Tech 14 is the place to be.

APEX or ADF? From Requirements to Tool Choice
APEX or (more...)