Vor kurzem musste ich Daten aus einer Excel-Liste in das SDO_GEOMETRY Format bringen. Leider hatte die Excelliste einen Haken.
Die Anforderungen: - Es musste eine Linie (Typ 2002) im GK3 Format (31467) aus VON und NACH Punkten generiert werden. - Die Excel-Liste hatte die Punkte entweder als GK3 oder als WGS84 Format hinterlegt.
Nach Import der Daten sah meine Quelltabelle dann so aus:
Und hier das Select zur richtigen Transformation der Geo-Daten ins SDO_GEOMETRY Format:
If using universal theme, we can switch from a classic navigation bar to a list and display it where usually a navigation bar is displayes - right top of the page. The problem with the list is that it will escape any html code in the list name. If we want to display an image, we will get the html code. To go arround that problem, we can use the "user defined attributes" for the (more...)
Looks like I forgot to put on my blog also this year we created a bet site for the European Cup Soccer. Thanks to the people who reminded me to put this post on my blog :)
It all started in 2006 when I first created a site to promote Oracle Application Express (APEX). The site allowed to bet on the games of the World Cup. At that time everybody was using Excel files internally (more...)
Interactive Reports (and Grids in 5.1) are one of the nicest features of Oracle Application Express (APEX) as it allows an end-user to look at the data the way they want, without needing a developer to change the underlying code. End-users can show or hide columns, do calculations on columns, filter etc.
Here's an example of an interactive report where highlighting, computation and aggregation is used.
It is incredibly quiet around APEX release 5.1. Just a couple of days ago I was talking to Dietmar and we were asking ourselves when is APEX 5.1 going to be released because of our training schedule for the rest of the year. Two days ago Markus visited the EA site and this is what he found there. Many exciting things to appear in the next versions. Read the details and you will (more...)
It’s here! Oracle Application Express 5.1 Early Adopter 1 is available at https://apexea.oracle.com/ and we are really looking forward to get your feedback (via the Feedback “Bubble” icon in the top right of the Builder)! A list of all new features … Continue reading →
We are very excited to announce the beginning of the Oracle Application Express 5.1 Early Adopter program, at https://apexea.oracle.com. The Early Adopter is an open-to-the-public hosted beta program. And we’re inviting everyone interested in Oracle Application Express - existing customers and new customers alike - to sign up for a free workspace and take our forthcoming release for a spin.
Inside an Interactive Report (IR) I had a comment column. The comments in this column could become really large and the users wanted the comments to be automatically trimmed if more then 60 characters were displayed. If the user moved the mouse above a trimmed comment then a tooltip should be display including all comment text.
My first idea was to check for existing plugins which could do this job for me. So I searched (more...)
A few days ago I got an email about an experiment how to program with the crowd.
I didn't really heard about it before, but found it an interesting thought. In this experiment people will perform microtasks (10 minutes task), as a member of the crowd. People don't know each other, but will collaborate together. The system is distributing the work and supplies instructions. The challenge is in creating quality code that meets the specifications.
Yes, you read that right - it's not a typo, nor did one of my kids or wife gain access to my laptop. It's part of a "blog hop" - where a number of experts made recommendations about KScope sessions that are "must attend" and are not in their core technology. I picked ADF/MAF, as I don't have any practical experience in either technology, but they are at least similar enough that I would not (more...)
I just came back from the DOAG APEX Connect 2016 conference in Berlin ... very nice location, great content and the wonderful APEX community to hang out with ... always a pleasure. This time we felt a little pinkish ;)
I just came back from the DOAG APEX Connect 2016 conference in Berlin ... very nice location, great content and the wonderful APEX community to hang out with ... always a pleasure. This time we felt a little bit pink ;)
How did you get started with developing your first APEX app?
My guess is either you went to https://apex.oracle.com and got a free account or Oracle Application Express was already in your company and somebody told you the url you could connect to. For me that is really the power of APEX, you just go to an url and within minutes you created your first app.
On 28th of April I will be presenting at APEX Connect in Berlin. The topic is Integration of APEX with HERE Maps. If you are interested to see how you can integrate APEX with Maps (HERE or Google or some other) please join the presentation. The best thing is that this integration ist done using APEX Plugins only. I will try to show as many functionalities as possible including Routing, Tracing, Positioning and a combination (more...)