Do you live in Perth, Western Australia?
Do you use Oracle Application Express?
Are you interested in seeing how easy it is to extend the product?
Keen to see APEX 5 in action?
Please tell me you're free for breakfast on Tuesday March 24. You'll be out by 9am feeling glad you came. Visit the event details page
for the abstract, it's inspired by a book I'm currently writing ;p
Sometimes I come across code where it's obvious someone has taught themselves APEX, then worked through a problem to come up with a solution - but they went a long
Today's situation required data in an interactive report to not wrap the output. I thought it'd be worth sharing because a few lessons might be demonstrated along the way for newer developers.
Here is the long way:
1) Add this to the Page Load (more...)
Thanks to twitter I found this post
by Carsten Czarski on LISTAGG and CLOBS that helped my with the 4000 character limit with LISTAGG(), found when building JSON strings.ORA-01489: result of string concatenation is too long
I follow a few bi-language blogs but I do wonder if English speakers may find this post when googling the issue. For me it's on page 1 when googling "listagg clob", but I knew what keyword to search (more...)
Once upon a time I had a laugh on facebook when someone posted an image
showing multiple groups dedicated to stopping duplicate groups, oh the irony.
Recently I've been trying to share my blog posts via LinkedIn but I'm always unsure which of the seven APEX groups I'm a member of I should post to.
It turns out only the SIG groups are owned by those involved with the APEX development team, namely David Peake (more...)
There are a bunch of sample APEX applications out there built by developers (typically with blogs) that are darn useful, but so far I haven't seen a useful central repository.
So I've started one here with a very basic form/report:https://apex.oracle.com/pls/apex/f?p=73000:APEX_SAMPLES
At the moment it's just a list of those I happened to have bookmarked over time, in one place that others could use and perhaps contribute to.
Depending on feedback I (more...)
Steven Feuerstein runs a great site at PL/SQL Challenge
that is just another way for developers to stay up to date with their knowledge of PL/SQL, SQL and database design with a bit of fun.
PL/SQL championships are held quarterly, but the less frequent SQL and Database Design quizzes are currently held annually. Thanks to persistence and maybe a bit of experience, I was eligible to compete in both.
Unfortunately do to a timing
Scott Spendolini conducted a little experiment
last week, then Jeff Smith & Kellyn Pot'Vin whipped up a little slideshow
on the topic.
I thought I'd chime in after some recent experiences were helped along by the use of Twitter, a tool it seems many are underutilising.
I had an afternoon of generating JSON with SQL using LISTAGG and I kept facing this issue of being limited by 4000 characters. Knowing I occasionally (more...)
I was inspired by Peter Raganitsch
to use the Survey Builder packaged application to create a survey that will help with my "Evidence Based APEX
I would appreciate 5-10 minutes of your time if you could fill out my survey:https://apex.oracle.com/pls/apex/f?p=70347:Q::AAC3
You'll find a small set of questions over five major topics.
- Instrumentation (debugging)
In time I'll discuss the results, I look forward to reading your responses.
I get this email that tells me apexea.oracle.com is about to be fitted out with an even slicker APEX5 Early Adopter 3.
|It's coming soon to a browser near you|
While playing with 12c I tried the upgrade to the DEFAULT column syntax that now allows sequences.
I came across a basic error, but it's just a small trap for new players.
CREATE TABLE seq_test(a NUMBER)
ALTER TABLE seq_test MODIFY (a NUMBER DEFAULT sage_seq.NEXTVAL)
SQL Error: ORA-02262: ORA-2289 occurs while type-checking column default value expression
*Cause: New column datatype causes type-checking error for existing column
default value expression.
*Action: Remove the default (more...)