31 October 2011
31 October 2011

Dynamic Show/Hide in APEX

0
Understanding is required before success is possible [Dune] old Orange Catholic Bible When you want to hide and display certain regions in an APEX based application based on the selection of the user, for instance when a button or a link is pressed then you can of course use the Region Display Selector, but this takes up a region on… Read more
21 October 2011
21 October 2011

APEX-Challenge.com

0
A few months ago we (APEX Evangelists) launched the APEX Challenge, a weekly quiz where you get a question about Oracle Application Express. Next to the fun of answering the questions and see your rank, you will hopefully learn something.… Read more
17 October 2011
17 October 2011

Introduction to Scheduled Jobs

2
Psst, wanna see something cool? I bet I can read your future. Your tomorrow is going to be almost exactly like your today; unless it’s a weekend, in which case it’ll be almost exactly the same as last weekend. You’re welcome: that’ll be ten quid. It is a truth that life’s events – and, by extension, computer operations – ar… Read more
12 October 2011
12 October 2011

Cloud Control 12c R1 Installation on Oracle Linux 5.7 & 6.1

0
Enterprise Manager Cloud Control is the new name for what was previously know as Enterprise Manager Grid Control. Depending on the source of the material, you may still see the product described as Grid Control. This article (read it in full on Oracle-Base.com) describes the installation of Oracle Enterprise Manager Cloud Control 12c Release 1 on Oracle Linux 5.7 and… Read more
11 October 2011
11 October 2011

What’s Your Choice for Oracle Forms?

4
Forms was a great tool and stood for fast and easy development.  You could create nice data entry applications in no time.  But now some people think Forms is dead, it doesn’t have a future or it is at the end of its lifecycle.  In this article I hope to prove they’re wrong.  And unlike the first sentence to prov… Read more
04 October 2011
04 October 2011

Introduction to Virtual Private Databases

1
  You know the story. A group of blind men come across an elephant and each one feels a part of it. One touches the tusk and goes away thinking elephants are pointy, hard and sharp; another feels its side and is amazed at how wide and featureless elephants are; and one unfortunate man feels the elephant up its backside,… Read more
27 September 2011
27 September 2011

Bulk Processing in Oracle Part 2

1
The process of learning requires not only hearing and applying but also forgetting and then remembering again. – John Gray Sending data back Using the bulk capabilities you can not only fetch data in one roundtrip to the database, but you can also use it to send data back to the database in a single roundtrip. Using the FORALL statement… Read more
23 September 2011
23 September 2011

Oracle Forms Survey

0
Posted by Gert Poel on the the iAdvise blog: I want to call all Oracle Forms developers and administrators to fill in this online survey about Oracle Forms. The results will be published during Oracle Open World. I’m interested in this topic (Forms and Forms Modernization) and I will be delivering a presentation at Oracle Open World about Oracle Forms(session… Read more
20 September 2011
20 September 2011

ORACLENERD T-Shirts

0
Recently I was asked to create some merchandise that fell outside of my norm. Specifically, I was asked to create a onesie, or piece baby outfit. I tried using my normal method of creating a simple png (pixel) graphic in gimp, however, when I tried to add that to something other than a regular old t-shirt, the application didn’t giv… Read more
19 September 2011
19 September 2011

Bulk Processing in Oracle Part 1

2
As you know (or may not know) there are two engines running in the Oracle database. The PL/SQL engine for executing all your PL/SQL code and the SQL engine for executing all you SQL statements. This means that every time your PL/SQL code needs data from the database, or writes to it control is passed from the PL/SQL runtime engine to the SQL.… Read more
14 September 2011
14 September 2011

Writing Better Dynamic SQL

0
Dynamic SQL is a powerful tool. In its proper place it can achieve quite a bit of work in a relatively small amount of code. Used improperly, however, it can cause all sorts of code maintenance headaches. Consider the following procedure. It uses the HR schema and sample data that comes with an installation of the Oracle database: CREATE OR… Read more
13 September 2011
13 September 2011

Red Gate Schema Compare for Oracle Review

0
From Geoff Hudik’s blog. As part of my recent role in application release management, I have had to compare and sync various objects across Oracle databases. This was not fun work and I decided to evaluate some different tools to make this easier. The tool I have been working with recently is Red Gate’s Schema Compare for Oracle. In this… Read more
07 September 2011
07 September 2011

APEX Plugin – Body Chart

0
Recently I had an inquiry via my website asking whether I was able to create a selectable body chart APEX plugin for a physiotherapy practice so they could easily highlight joint pain and record information against these selected areas. One of the challenging requirements was to allow fine grained selectivity of 16 areas on each… … Read more
06 September 2011
06 September 2011

Introduction to Regular Expressions in Oracle

17
Regular expressions – RegEx or RegExp to their friends – were fashionably late in coming to the Oracle party. The seeds of what we know today as regular expressions were formulated in the period immediately following the Second World War in fields as diverse as formal language theory and neurophysiology; but it wasn’t until the PL/SQL Web toolkit arrived for… Read more
02 September 2011
02 September 2011

Collections in Oracle Part 2

0
“The process of learning requires not only hearing and applying but also forgetting and then remembering again.” John Gray. This article follows on from Collections in Oracle Part 1 Varray The syntax for defining a varray in SQL is like this: CREATE OR REPLACE TYPE varray_type AS VARRAY(SIZE) OF element_type; The syntax for defining a varray in PL/SQL is lik… Read more