I just ran the following script:-- TABLESFOR x IN (SELECT table_name FROM user_tables)LOOP EXECUTE IMMEDIATE('DROP TABLE ' || x.table_name || ' CASCADE CONSTRAINTS');END LOOP;
-- SEQUENCESFOR x IN (SELECT sequence_name FROM user_sequences)LOOP EXECUTE IMMEDIATE ('DROP SEQUENCE ' || x.sequence_name);END LOOP;
-- VIEWSFOR x IN (SELECT view_name FROM user_views)LOOP EXECUTE IMMEDIATE ('DROP VIEW ' || x.view_name);END LOOP;
About a month ago, I left my position at Accenture Enkitec Group. I had a couple of ideas as to what I wanted to do next, but nothing was 100% solid. After considering a couple of different options, I'm happy to announce that together with Doug Gault & Tim St. Hilaire, we're re-launching Sumner Technologies.
Much like last time, the focus will be on Oracle APEX; but we’re going to refine that focus a little (more...)
Just under three years ago, I joined Enkitec when they acquired Sumneva. The next three years brought a whirlwind of change and excitement - new products, additional training, and expanding the APEX practice from an almost nonexistent state to one of the best in the world.
Like all good things, that run has come to an end. Last Friday was my final day at Accenture, and I am once again back in the arena of (more...)
Last week, I participated in my first Little League draft for my son's baseball team. This was new territory, as up until now, play has been non-competitive. This year we will actually have to keep score, and there will be winners and losers.
In preparation for the draft, we had tryouts a few weeks ago where we evaluated the kids on a number of different criteria. Never have I seen so many scared 7 and (more...)
Every time I attend a conference, the Twitter traffic about said conference is obviously higher. It starts a couple weeks or even months before, builds steadily as the conference approaches, and then hits a crescendo during the conference. For the past few conferences, I’ve started my sessions by asking who in the audience uses Twitter. Time and time again, I only get about 10-20% of the participants say that they do. That means that up (more...)
The big news about Oracle APEX from OOW is not so much about what, but more about when. Much to many people's disappointment, APEX 5.0 is still going to be a few months out. The "official" release date has been updated from "calendar year 2014" to "fiscal year 2015". For those not in the know, Oracle's fiscal year ends on May 31st, so that date represents the new high-water mark.
Despite this bit of (more...)
Steven Feuerstein (https://twitter.com/stevefeuerstein
) just tweeted this:
Which in turn, inspired me to quickly write this post.
The combination of being in IT and working from home leads to lots of hours logged in some sort of chair, whether its in (more...)
The next Meetup for the ORCLAPEX NOVA Meetup Group will be this Thursday, July 17th at 7:00PM at Oracle Reston. (Details: http://www.meetup.com/orclapex-NOVA/events/192592582/
We're going to try the "Open Mic" format that has been wildly successful at KScope for the past few years. The rules are quite simple: anyone can demonstrate their APEX-based solution for up to 10 minutes. No need to reserve a spot or spend too much time planning. And as (more...)
For the upcoming inaugural ORCLAPEX NOVA MeetUp on May 29th, not only will we have Mike Hichwa, Shakeeb Rahman and David Gale from the Reston-based Oracle APEX development team present, but we will also have the entire Columbus, OH based APEX team in attendance, as well: both Joel Kallman and Jason Straub will be in town and have RSVP’ed to the MeetUp!
Outside of major conferences such as KScope or OpenWorld, there is (more...)
Recently, I was working with one of our customers and ran into a rather unique requirement and an uncommon constraint. The customer - Storm Petrel - has designed a grant management system called Tempest. This system is designed to aid local municipalities when applying for FEMA grants after a natural disaster occurs. As one can imagine, there is a lot of old fashioned paperwork when it comes to managing such a thing.
Thus, the (more...)
Following in the footsteps of a few others, I’m happy to announce the formation and initial meeting of the ORCLAPEX NOVA (Northern Virginia) group!
As Dan McGhan and Doug Gault have mentioned in their blogs, a bunch of us who are regular APEX users are trying to continue to grow the community by providing in-person meetings where we can meet other APEX developers and trade stories, tips and anything else. Each of the groups (more...)
On Thursday, February 27th, I will be taking over @WorkingOrange - the Syracuse University Career Services Twitter account.
WorkingOrange was created to allow Syracuse alumni from all fields to share what it is they do on a typical day, as well as interact with students, other alumni and anyone else. It is typically active each Tuesday and Thursday, and has hosted alumni from all kinds of industries. For example, today is an elementary school teacher, (more...)
It’s that time of year again: Conference Season! There’s a few conferences that fall in the 1st few months of the year that I try to present at each year, and this year is no different. Here’s where I’ll be presenting at over the next few months:
- RMOUG - Denver, CO - February 5th - 7th
At RMOUG this year, I’ll be co-presenting a new session called “Creating a Business UI in APEX” with Jorge (more...)
Yesterday, we launched the new APEX Resource Center - or ARC - on enkitec.com. The ARC was designed to provide the APEX experts at Enkitec with an easy way to share all things APEX with the community. It’s split up into a number of different sections, each of which (more...)
Yesterday, I was part of the KScope 14 APEX Abstract Review call. This call is used to discuss the rankings that the Abstract Review Committee has previously given each session. Naturally, we use APEX to help with this process - specifically WebSheets. The call allows us to ensure that the (more...)
My OCD was delighted this morning when I came across a new feature of SQL Developer: Connection Color. Brace yourselves, as this feature ain't much, but could have a huge impact on reducing accidental commands in the wrong schema or server.
To use it, simply create or edit a database (more...)
APEX 4.2.3 seems to be largely a maintenance release, with few new features added. (Full details of what is included can be read here: http://www.oracle.com/technetwork/developer-tools/apex/application-express/apex-423-patch-set-notes-2015119.html
Despite this fact, there are a couple of new "features" that were added by way of a new packaged (more...)
I found a great blog post by Tom Petrus that summarizes the power of the APEX tree here: http://tpetrus.blogspot.be/2013/01/working-with-tree-in-apex.html
The post details a number of different attributes of the tree and how to interact with it. It starts simple and shows how to get a tree reference (more...)
Looks like the Oracle APEX team's annual OOW site is live here: http://apex.oracle.com/pls/apex/f?p=67165:1
This site provides a list of APEX-related sessions at OOW in both a calendar and list view. It is also mobile friendly, which will make it nice to have while at the (more...)