//AMIS Technology Blog » regular expressions

Posts tagged regular expressions

image.png

Valuable Java, JavaScript and ADF resources

0
10 months ago
by Lucas Jellema in , , , ,

In the past few days, I have been working hard on several projects – both ADF and (plain) Java based, with quite a bit of JavaScript involved as well. The three main functional challenges:

  • support keyboard (function key based) navigation in rich ADF Web pages (in addition to mouse based actions)
  • support online and inline editing of customized (per context) resource bundle entries
  • create a stand-alone viewer that allows users to inspect images (jpeg, tiff), PDF documents and Word and Excel documents

While working on these requirements, I have used – through Google, my main tool – a large number of very valuable resources on the internet. From the Oracle Technology Network Forums (OTN) to StackOverflow (http://stackoverflow.com), from personal blogs to corporate white papers as well as formal documentation – I have picked an incredible number of brains in a very condensed period of time.

I did not stop to leave notes of gratitude on all the sites I have come across. So I thought – for my own future reference as well as to pay some hommage to all these sites and individuals that helped me and to provide some insight in what challenges I faced and how I addressed them – to write More >

Vacatures bij AMIS services

Update day to second interval column in selection from time gaps table by parsing strings containing time differences using REGEXP_SUBSTR

2
1 year ago
by Lucas Jellema in , ,

An apparently trivial challenge that still took me bit longer than expected. What is the situation: I have a table with two columns (of interest). One is a column called gap, with values like these:

Each value represents a time difference. These values are strings – not much use to calculate with. Therefore a second column in the table – called timegap – is defined, of type INTERVAL DAY TO SECOND. The challenge I am facing is to set the value of this column timegap based on the time difference described by the string in column gap.

With a little bit of SQL agility, using for example some regular expressions and an interesting update on [the result of] an inline view, it turns out to be doable in a fairly simple SQL statement.

(more…)

Go to Top