Weblog for the AMIS Technology corner
Patrick Sinke
Posts by Patrick Sinke
Custom authentication in Apex (part 1)
29/11/2007 - 11:58 am
Posted in Database, Devel. + PL/SQL tools, Oracle, Software Development | 6 comments
Another word for authentication is acces control.
Authentication is the mechanism to verify the user’s identity and
provide access to a system or application based on the credentials
entered by the user. Authorization, on the other hand, says something about the degree of access granted to resources.
For
authentication, different methods exist in Apex. The most basic one is
‘no [...]
and now we present… 11g and Apex on Ubuntu
29/11/2007 - 10:46 am
Posted in Database, Devel. + PL/SQL tools, KC Oracle Development Tools, Software Development | No comments
Thanks to a completed messed-up Windows (I managed to demolish my network connections beyond repair) and a helpful tutorial from Dizwell’s blog (thank you oh so very much!) I installed Ubuntu 7.10 (codenamed Gutsy Gibbon) on my laptop, and afterwards, Oracle 11g. I probably wouldn’t have made without Google and especially Dizwell’s tutorial, but in [...]
Importing Access applications into Apex
19/9/2007 - 7:30 am
Posted in Database, Devel. + PL/SQL tools, General, KC Oracle Development Tools, Oracle | 2 comments
Some time ago I’ve been experimenting with the Apex 3.0 feature that migrates entire Access applications to Application Express. It took me a lot of time because I found out the path to it is winding and bumpy. I would like to share some of my issues here. A very good tutorial is found at Oracle’s OTN [...]
Check out the Apex 4.0 preview at Carl Backstrom’s blog!
18/9/2007 - 12:42 pm
Posted in Database, Devel. + PL/SQL tools, Oracle | 4 comments
The live demo presented by Carl Backstrom as presented to the attendees of the Apex European Training Days is now publicly available!
You can review at Carl’s blog , and if you got a few minutes spare time, you should take a look. I think the reporting features of Apex 4.0 are simply jawdropping. The out [...]
Searching the AMIS Weblog directly from your Firefox searchbar
29/7/2007 - 6:43 pm
Posted in General, Software Development, XML | No comments
Why bother using Google if you know you will find the answer on this blog anyway? It would be a nice feature if you could search directly from your Firefox searchbar then, right?
Alex just pointed out he already created a plugin before me: http://technology.amis.nl/blog/?p=764
I made one small improvement, that is I embedded the image in [...]
How to calculate the Easter date in PL/SQL
22/6/2007 - 12:09 am
Posted in Database, General, Oracle | 5 comments
Ever wondered how they Easter date is determined? And, even more important, how it is to be maintained in you application. Manually updating the date every year is an option, but it’s always better to calculate it on the fly. It’s not easy because it depends on the age of the moon at january 1st [...]
Creating a shuttlebox in Apex
17/5/2007 - 3:52 pm
Posted in Database, Devel. + PL/SQL tools, General, Oracle, Software Development | 3 comments
The changelog of Apex 3.0 mentions something about featuring shuttleboxes. Don’t get too enthousiastic, you still have to do a lot of work yourself. And it’s pretty limited, because this feature assumes the use of static values. That’s not what we want! We want dynamic information from the database! Here’s a demonstration of a DIY [...]
How upgrading to Apex 3.0 spoiled my weekend!
4/4/2007 - 12:09 am
Posted in Database, Devel. + PL/SQL tools, KC Oracle Development Tools, KC SDPL, Oracle | 1 comment
Allright, that is an exaggeration. Hugely. But it cost me some headache before I realised what was my problem.
I still had HTML DB 1.6 running and I thought it was time I upgraded to the only just released version 3.0. So I downloaded the zip-file, and followed the instructions in the manual. Those instructions include [...]
About hierarchical queries, filling the gaps and doing stuff in ApEx
24/3/2007 - 1:36 am
Posted in Database, Devel. + PL/SQL tools, Oracle, Software Development | No comments
Sometimes you are writing some codes and things really come together well.
Let’s imagine, you are writing a little tool in ApEx for registering hours on a project. The hours are recorded in a table which contains all days of the week and a week number (and employeenumber and projectnumber). One region on the page shows [...]
Removing double records (and keeping one of them)
15/2/2007 - 4:55 pm
Posted in Database, KC DBA, Oracle, Software Development | No comments
Assume you have a table with contaminated data (in this example: non-unique values on col1 and col2), for instance because no unique key was implemented.
col1 col2 value
2 9 Smith
2 4 Jones
2 9 Andersen
8 [...]
