May 27 2011
Trying here to be as correct as possible, as far as I understand it currently. ANONYMOUS is an Oracle user account specifically designed for HTTP access. It has only one system privilege, that is “create session” and the account is locked by default. If it is unlocked, it only is used for HTTP access via …
May 23 2011
Most XML datetime information is represented like the following: <date>2011-05-23T12:01:51.217+02:00</date> So said that, how do you get from that format to a Oracle datetype… The following will help converting you from the W3C datetime towards Oracle datetypes… WITH datestuff AS (SELECT xmltype(’<date>2011-05-23T12:01:51.217+02:00</date>’) xmlcol FROM dual ) SELECT to_timestamp_tz(xt.datum,’YYYY-MM-DD"T"HH24:MI:SS.FF9tzh:tzm’) AS "TO_TIMESTAMP_TZ" FROM datestuff , xmltable(’*’ passing …
May 20 2011
Ook dit jaar, namelijk op dinsdag 14 Juni, organiseert AMIS de ODTUG Preview. Het jaarlijkse congres van de ODTUG, de Oracle Development Tools Users Group, vind dit jaar plaats in Longbeach, California van 26 tot en met 30 juni. Het is niet voor iedereen weggelegd om daar naar toe te gaan. AMIS biedt, alweer voor …
May 19 2011
Roel Hartman and me are currently very busy with our Kaleidoscope 2011 presentation “XFiles, the APEX Version: The Truth is in There…“. During this presentation, we will demonstrate the awesome possibilities you can create when you combine the APEX and XMLDB functionality of the APEX database environment. And as you probably also know, two “no …
May 19 2011
I needed to update my Flipshare software and get some of the movies made from my Flip when I noticed that current owner Cisco will close down its Flip business and support current FlipShare customers and partners. Probably it was never a good idea of Cisco to go in “the movie” business anyway… It’s a …
May 18 2011
Sometimes the answer can be so simple… I wanted to reset the OTN Developer Days Virtualbox APEX Listener admin password without redeploying the apex.war file and destroying the current setup, so I searched all config and properties APEX Listener files I could find. Searched via Google. No useful hits. I found a credential file with …
Recent Comments