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;
Actually this came as a wonderful surprise ... I have been nominated for the Oracle Database Developer Choice Awards:
I have basically devoted my entire work life to build solutions based on Oracle technology ... and you can build some pretty cool stuff with it. I have always enjoyed building software that makes a difference ... and even more so share to what I have learned and support and inspire others to do the same. (more...)
In the first part of October, my colleague Vlad Uvarov
and I are taking the Oracle APEX
& Oracle Database Cloud
message to a number of user groups who are graciously hosting us. These are countries for which there is growing interest in Oracle Application Express, and we wish to help support these groups and aid in fostering their growing APEX communities.
The dates and locations are:
- Latvian Oracle User Group, October 5, 2015
in June I gave a talk at the ODTUG KScope conference regarding the optimal setup of Oracle ORDS for Oracle Application Express: Setting Up the Oracle APEX Listener (Now ORDS) for Production Environments
You can access the slides certainly through the ODTUG site. They have even recorded the presentation and made it available to their members.
This seems to be a good investment for $99 per year for a paid membership, because now (more...)
The Universal Theme in APEX 5.0 is full of nice things.
When you add a region to your page with a couple of sub-regions and you give the parent region the "Carousel Container" template it turns the regions into a carousel, so you can flip between regions.
I was asked to have the same functionality but than on dynamic content.
Ich habe in der Oracle DB Welt viele Themenkomplexe kennengelernt und mit gearbeitet. Eines ist bisher außen vor geblieben: Oracle Spatial mit dem Datentyp SDO_GEOMETRYWarum?
Es hat sich wohl einfach noch nicht ergeben.
Aber irgendwann ist ja immer das erste Mal! :)
Heute habe ich die Aufgabe erhalten bestehende Koordinatendaten (X,Y) in das SDO_GEOMETRY Format GK3 zu transformieren.Was wusste ich bisher?
Der SDO_GEOMETRY Datentyp wird über ein gesondertes Schema bereit gestellt:
Viele APEX Anwendungen benötigen zur korrekten Ausführung User-spezifische nicht veränderbare Variablen. Auf diese Variablen bezieht man sich, um sicherheitsrelevante Abfragen für den angemeldeten User auszuführen.Hier eine kurze Liste an möglichen Anwendungsfällen:
- User ID
- User basierte Parameter
(Land / Region / Ort / Niederlassung / Firmen- und Anwendungsspezifische Hintergründe)
- Rechte und Rollen
- Berechtigungen auf Zeilenebene
- Schreib- und Leserechte Diese Variablen sollten je nach Inhalt und Verwendung auf eine der (more...)
APEX 5 comes with Modal Dialogs out of the box. Very neat. Especially for adding and changing data. And to minimise the number of time a user has to click, it could be useful to add a "Close Dialog
" process after the actual data processing. When the data processing fails, the Dialog stays on top showing the error. When data processing runs fine, the Dialog is closed ... without any confirmation. And this might (more...)
This small example
is showing hot to make sure at least one row in your tabular form has been selected prior to proceeding: https://apex.oracle.com/pls/apex/f?p=93000:806
This is definitely worth of mentioning. Go here
and download this plugin for Firefox or Chrome. You will like it. It switches the panes in the Page Designer so you can much easier access the properties of the selected elements. Congrats Filip
. This is a cool feature. Thanks.
During my holiday Apress released the second edition of Expert Oracle Application Express.
In the second edition we not only updated the content to APEX 5.0, but there're some new chapters in too from new authors. In total you get 14 chapters from 14 different authors.
I believe it's a very nice book with great content and it's for a good cause. Roel describes it very nicely in his blog post
"the goal (more...)
It took a while, but last month the second edition of the Expert Oracle Application Express
was released. It is the natural successor of the first edition (duh), but its not just that. Some of chapters are updated for APEX 5, but about half of the chapters are completely new
! And that means also half of the authors are new as well. Because this is a joint project, 14 authors, 14 chapters, one goal. And (more...)
If you're not aware, there is an APEX Gaming Competition
which is already underway, and which is sponsored by the Oracle Development Tools User Group (ODTUG)
. For those who don't know what ODTUG is
, it is an independent user group and community of professionals, with a primary focus on the tools, products, and frameworks to build solutions and applications with the Oracle technology stack. Although ODTUG is based in the USA, they have members (more...)
Expert Oracle Application Express 2nd Edition seems to be available at Apress
. Buy this book and support the charity project in memory of Carl Backstrom
and Scott Spadafore
(previous members of the APEX Team). Please note that all
funds will be donated to the families of these two great men.
is a new blog on APEX. I expect a lots of good stuff there in the future. The last example describes how to modify the Page Designer and move the panes, adjust the layout and simplify the development of an application since accessing element attributes is much easier that way. I think this is worth of looking at and maybe the APEX team considers this as an improvement for the future release.
I know some people waiting till the first patch set that comes available after a major Oracle APEX release... today you no longer have to wait, APEX 5.0.1 is now available.
In the patch set notes
you can read what changed.
If you're still on APEX 4.x you can go immediately to APEX 5.0.1, you only need to download
the latest version on OTN.
If you're already on APEX 5. (more...)
Oracle Application Express 5.0.1 is now released and available for download. If you wish to download the full release of Oracle Application Express 5.0.1, you can get it from the Downloads page on OTN. If you have Oracle APEX 5.0.0 … Continue reading
is showing how to open a Modal Page from any element in your application. It is easy to get it working using some standards like a button or a link in a report. However, it is not 100% clear how to get it working with some other elements which don't have the redirect functionality built in (item, region title, custom links, etc.). This example is also showing how to get the success (more...)
Oracle Application Express 5.0 wurde am 15.04.2015 freigegeben und ist als Download verfügbar.
Wir haben jetzt alle über zwei Jahre auf das neue Release gewartet ... und das Warten hat sich mehr als gelohnt ... die neuen Möglichkeiten werden Sie umhauen!
Wir haben die neuen Möglichkeiten genau unter die Lupe genommen und sind selbst total begeistert, weil sie das tägliche Arbeiten extrem vereinfachen. Wir haben schon einige Anwendungen in APEX 5.0 neu programmiert (more...)
APEX 5.0 has been released this spring. People who have already spent some time on this new version know this version is packed with new features aimed to make APEX developers even more productive, like the Page Designer.
Another striking new subset of features is aimed at creating better looking user interfaces for your APEX applications in an easy and maintainable way.
The definition of user interface components in APEX 5.0 is very (more...)