Pins Polygons and Perspectives

July 11, 2014 at 2:53 pm | Posted in Oracle Developement | Leave a comment

This is the presentation I gave at KScope 14 in Seattle this year.

Ever wonder how much easier it would be to make sense of your geographic data if you could visualize it? Learn how to free your geographic data from the confines of your tables, and render it in colorful pins and polygons, to provide you with a better perspective.

Pins Polygons and Perspectives

Oracle ACE Associate

June 11, 2014 at 10:23 am | Posted in Oracle Developement | 1 Comment

Oracle ACE Associate

I have received the honor of becoming an Oracle Ace Associate. I’m proud and humbled to be part of this group of technical Oracle experts, and hope to live up to their standards.

A new future for Enkitec

May 15, 2014 at 2:25 pm | Posted in Oracle Developement | Leave a comment

Enkitec has been acquired by Accenture. We’re very excited about this move, and the new opportunities it brings.

More details at Enktec.com.

Random Data Generator

April 9, 2014 at 2:54 pm | Posted in Oracle Developement | 1 Comment
Tags: , , , ,

Today I came across this awesome website which will automatically generate data for you, and spit it out in different formats. These include XML, CSV, Excel, and more. But the coolest format of course is Oracle SQL. The website will generate the table creation script and the insert statements for your data:

CREATE TABLE myTable (
 id number primary key,
 name varchar2(255) default NULL,
 city varchar2(255),
 age varchar2(50) default NULL,
 zip varchar2(10) default NULL,
 PRIMARY KEY (id)
) AUTO_INCREMENT=1;

INSERT INTO myTable (name,city,age,zip) VALUES ('Ian Parks','New Orleans',15,'8587');
INSERT INTO myTable (name,city,age,zip) VALUES ('Silas Blackburn','Dunbar',40,'97129');
INSERT INTO myTable (name,city,age,zip) VALUES ('Kenyon Hammond','Varsenare',60,'6744');

Note: You may have to work with the quotes.

How cool is that?

I’ve previously blogged about another way of generating random data, so take a look at

Generating Data: Increase a number by a random percentage

Configuring Logging in Oracle Application Express Listener 2.0.1

March 26, 2014 at 3:46 pm | Posted in Oracle Developement | Leave a comment

Christoph Ruepprich:

Here is an excellent post about enabling logging in the Apex Listener/ORDS.

Originally posted on cdivilly:

Simple Logging

The easiest way to turn logging on in Listener 2.0.1 is to use Oracle SQL Developer to turn on the debug.debugger setting:

  • Launch SQL Developer
  • Select View|APEX Listener from the main menu
  • Right click on Listener and choose Connect...
  • Choose an existing connection or create a new connection
  • Enter the credentials for the Listener Administrator user
  • In the tree view naviagate to the Listener>Administration>Global Settings>Environment>Error Reporting node. Tick the Show debug messages on the console option.
  • Click the Upload button from the toolbar (5th from left), and click yes to confirm the upload.
  • The changes will immediately take effect on the Listener instance

Alternatively if your prefer you can edit the defaults.xml Listener configuration file directly. Adding the following to the file to enable logging:
1
You must restart the Listener instance after editing defaults.xml manually.

Displaying logging information on the Error Page

Listener can be…

View original 941 more words

Meet “edb360″: a free tool that provides a 360-degree view of an Oracle database

February 20, 2014 at 9:50 am | Posted in Oracle Developement, Oracle Performance, Oracle Tools, PL/SQL | Leave a comment
Tags: , , , ,

Meet "edb360": a free tool that provides a 360-degree view of an Oracle database.

Excel Style Row Numbering in SQL

February 3, 2014 at 12:59 pm | Posted in Oracle Application Express (Apex), Oracle Developement, Oracle Tools | Leave a comment
Tags: , , , , , , , , ,

Here is a trick to change your rownumbering (or any other sequential numbering) to the way Excel names their columns. The first 26 rows will be named A – Z, the next 26 AA – AZ, then BA – BZ, etc..

SELECT decode( ceil( ( ROWNUM / 26 ) - 1)
             , 0, ''
             , chr( ceil( (ROWNUM/26)-1 ) + 64)
             )
     || chr(64 + decode( MOD(ROWNUM, 26)
                       , 0, 26
                       , MOD(ROWNUM, 26)
                       )
            ) col2
 FROM dual
CONNECT BY LEVEL <= 702; --limits the result to 702 rows 

Result:
Row	Label
---------------
1	A
2	B
3	C
4	D
5	E
	…
28	AA
29	AB
30	AC
31	AD
32	AE
	…
698	ZV
699	ZW
700	ZX
701	ZY
702	ZZ

Note that this will be good for 702 rows (nbr_of_letters * (nbr_of_letters+1)). After that you’d have to concatenate a third character, or write a function.

Speaking at RMOUG Training Days 2014

February 3, 2014 at 11:21 am | Posted in Oracle Developement | Leave a comment
Tags: , , , , , , , ,

I’m honored to be allowed to present at this year’s RMOUG Training Days. My presentation Making Sense of Application Express Security, will cover some of the basics of Apex security. I’ll cover various authentication types and how they can be used, how to use authorization schemes to control what applications and application elements users have access to, and also touch on session state protection and URL tampering.

Hope to see you there!

2013 in review

December 31, 2013 at 9:21 am | Posted in Oracle Developement | Leave a comment

The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog.

Here’s an excerpt:

Madison Square Garden can seat 20,000 people for a concert. This blog was viewed about 63,000 times in 2013. If it were a concert at Madison Square Garden, it would take about 3 sold-out performances for that many people to see it.

Click here to see the complete report.

Enkitec APEX Resource Center

December 18, 2013 at 3:17 pm | Posted in Oracle Developement | 2 Comments
Tags: , , ,

I’m proud to announce the launch of the Enkitec APEX Resource Center (aka ARC) this week. It consists of a number of APEX and PL/SQL specific articles, tips & tricks, how-to’s and demos.

Read some more about it at Scott Spendolini’s blog.

Next Page »

Create a free website or blog at WordPress.com. | The Pool Theme.
Entries and comments feeds.

Follow

Get every new post delivered to your Inbox.