APEX-AT-WORK by Tobias Arnhold: Personal stuff

Browsing "Older Posts"

Browsing Category "Personal stuff"

Update of my example application

Von Tobias Arnhold → 10.08.2009

Hi!

Out of some reason Oracle does not provide the applications from the APEX Developer Competition 2009.

Some winners already provided there applications:
Matt Nolan: APEX Plugin Registry Application
Martin Giffy D'Souza: APEX Rules & Guidelines

I just updated my example application as well:
APEX-AT-WORK Developer Competition 2009 Edition
Description: This application is an upgrade of the original APEX-AT-Work Example application. It includes lots of new examples, a new layout, new techniques (like screen casts) and an extended documentation. It is not a normal APEX application which includes lot's of business logic. This application shows how to use the new technologies out there. The core is based on a javascript library called ExtJS. This library creates a completely new look and feel which makes APEX even nicer to use. But also rarely used APEX WEB 2.0 features are integrated based on typical examples.

About the competition:
Oracle.com: Oracle Application Express Developer Competition 2009
David Peake's Blog: Winners of APEX Developer Competition 2009
OTN Blog: Congrats to the Oracle Apex Developer Competition 2009 Winners
Oracle.com: Rules

I must object another behavior what I can't understand. Why aren't there any jury judgments. I really would have loved to know what for example Dimitri thought about my application. I guess all other developers think the same.

Anyway I wish everybody a really exciting OOW.

Upgrade to a journeyman

Von Tobias Arnhold → 9.10.2009

I did it. I finally reached the next level in the Oracle APEX forum:

Ok ok I know that the most APEX experts work much harder inside the forum and they know things I haven't even heard yet. But that is the psychological hurdle to get even further...

Have a nice day.

Tobias

Personal stuff

It's time for a new revolution - Update of my example app

Von Tobias Arnhold → 6.09.2009

For those who are interested in APEX, ExtJS and AJAX take a look on my new/updated example application:
http://apex.oracle.com/pls/otn/f?p=65555

Feel welcome to post some feedback!

I don't know if you have noticed it yet? ;D I updated my blog layout as well.

Personal stuff

Terrific Oracle forum exemplified by "wi (dd.mm.yyyy-dd.mm.yyyy)"

Von Tobias Arnhold → 2.20.2009

Did you ever had any problems with Oracle based issues like Database, APEX, Forms, SQL and so on? Of course you had.
Normally the Oracle Metalink is the first address for everybody who has a contract with Oracle. But in some cases the Oracle forum help is unbeatable.
What I mean is. Whenever you have a problem with SQL commands or APEX issues the fastest way to find a solution is to ask in the Oracle forums.

I want to bring up a special example I had. I needed some week and date values via a sql command for a month like that:
wi (dd.mm.yyyy-dd.mm.yyyy)
05 (01.02.2009-01.09.2009)
06 (02.02.2009-08.09.2009)
07 (09.02.2009-15.09.2009)
08 (16.02.2009-22.09.2009)
09 (23.02.2009-28.09.2009)

I couldn't fix it myself so I wrote a forum entry:
http://forums.oracle.com/forums/message.jspa?messageID=2842808
I got more then a tip I got a solution for the problem.

A couple of weeks later I just found out that the last week in February was missing. So I wrote a new post which was answered just a couple of hours later.
http://forums.oracle.com/forums/message.jspa?messageID=3279392

I think this type of help is sometimes more valuable then any GOLD support you can get. :D

By the way here is the solution for the problem: ;D


-- select all weeks for a year
select to_char(dt+(7*rn),'WW') ||' ('||
       to_char(dt+(decode(rn,0,0,(7*rn)+1-offset))) ||'-'||
       case when dt+(7*(rn+1))-offset > last_day(dt) then
                   last_day(dt) ||')'
              else
                   dt+(7*(rn+1))-offset ||')'
              end as show_value,
       to_char(dt+(7*rn),'WW') as return_value
  from (select to_date(mes||'2009','MMYYYY') as dt, to_number(to_char(to_date(mes||'2009','MMYYYY'),'D')) as offset
         from dual, (select to_char(rownum, '00') mes from dual connect by rownum <= 12))
       ,(select rownum-1 rn from dual connect by rownum <= 6) 
where trunc(to_date(dt+(decode(rn,0,0,(7*rn)+1-offset))), 'MM') = dt
order by dt, return_value asc
-- select all week for a month
select to_char(dt+(7*rn),'IW') ||' ('||
       to_char(dt+(decode(rn,0,0,(7*rn)+1-offset))) ||'-'||
       case when dt+(7*(rn+1))-offset > last_day(dt) then
                   last_day(dt) ||')'
              else
                   dt+(7*(rn+1))-offset ||')'
              end as show_value,
       to_char(dt+(7*rn),'IW') as return_value
  from (select to_date(02||2009,'MMYYYY') as dt from dual)
       ,(select to_number(to_char(to_date(02||2009,'MMYYYY'),'D')) as offset from dual)
      ,(select rownum-1 rn from dual connect by rownum <= 5) 
  where trunc(to_date(dt+(decode(rn,0,0,(7*rn)+1-offset))), 'MM') = dt
-- the way I use it in APEX
select to_char(dt+(7*rn),'IW') ||' ('||
       to_char(dt+(decode(rn,0,0,(7*rn)+1-offset))) ||'-'||
       case when dt+(7*(rn+1))-offset > last_day(dt) then
                   last_day(dt) ||')'
              else
                   dt+(7*(rn+1))-offset ||')'
              end as show_value,
       to_char(dt+(7*rn),'IW') as return_value
  from (select to_date(:P1_MONTH||:P1_YEAR,'MMYYYY') as dt from dual)
       ,(select to_number(to_char(to_date(:P1_MONTH||:P1_YEAR,'MMYYYY'),'D')) as offset from dual)
      ,(select rownum-1 rn from dual connect by rownum <= 5) 
  where trunc(to_date(dt+(decode(rn,0,0,(7*rn)+1-offset))), 'MM') = dt

Special thanks to BluShadow and Miguel Chillitupa!

Personal stuff

First apex-at-work blog

Von Tobias Arnhold → 8.10.2008

In my first blog I want to give a preview what you can expect from this blog in the future.

This blog spins around Oracle APEX and all you can imagine could have to do with it, for example: