Skip to main content

Events


Upcoming (2023) events:
  • MakeIt/SIOUG 2023, Jun 1-2, Portoroz*)
  • Kscope23, Jun 25-29, Aurora (CO)*)

Visited events:
    2023
  • RMOUG Training Days, Feb 16-17, Denver*)
  • APEX World, Mar 30-31, Zeist
  • OUGN, Apr 24-25, Oslo*)
    2022
  • APEX Alpe Adria, April 21-22, Maribor*)
  • APEX World, May 24-25, Zeist*)
  • Kscope22, June 20-23, Dallas*)
  • OUG Ireland, Sep 5-6, Dublin*)
  • RoOUG, Oct 6-7, Bucharest*)
  • HrOUG, Oct 11-14, Rovinj*)
  • Oracle Cloud World, Oct 17-20, Las Vegas
  • UKOUG Breakthrough 22, Dec 1-2, Birmingham*)
    2021
  • POUG 2021, Sep 10-11, Warsaw*)
  • APEX World, Sep 29-30, Zeist*)
  • UKOUG, Nov 29-30, London*)
    2020
  • ILOUG, Feb 3-4, Tel Aviv*)
  • APEX World, Mar 16-17, Rotterdam*) ** cancelled **
  • APEX Alpe Adria, Apr 24, Maribor*) ** cancelled **
  • APEX Connect, May 5-7, Bruhl*) ** cancelled **
  • Full Stack Developer Conference, May 19-20, Helsinki*) ** cancelled **
  • Kscope20, Jun 28-Jul 2, Boston** cancelled **
  • POUG 2020, Sep 11-12, Warsaw*)
    2019
  • APEX World, Mar 25-26, Rotterdam*)
  • APEX Alpe Adria, Apr 12, Zagreb*)
  • APEX Connect, May 7-9, Bonn*)
  • Kscope19, Jun 23-27, Seattle*)
  • Oracle Open World / CodeOne, Sep 16-19, San Francisco*)
  • BGOUG, Nov 15-17, Pravets*)
  • DOAG, Nov 19-21, Nuremberg
  • UKOUG Tech19, Dec 1-4, Brighton*)
  • Sangam19, Dec 6-7, Hyderabad*)
    2018
  • ILOUG, Jan 22-23, Tel Aviv*)
  • OUG Norway, Mar 8-10, Oslo-Kiel-Oslo*)
  • APEX World, Mar 22-23, Rotterdam*)
  • MalagAPEX, May 31-Jun 1, Malaga*)
  • KScope, Jun 10-14, Orlando*)
  • POUG18, Sep 7-8, Gdansk*)
  • SIOUG, Oct 15-16, Portoroz, Slovenia*)
  • HROUG, Oct 16-19, Rovinj, Croatia*)
  • Oracle Open World / Oracle CodeOne, Oct 22-25, San Francisco*)
  • DOAG, Nov 20-22, Nuremberg*)
  • UKOUG Tech18, Dec 2-5, Liverpool*)

  • 2017
  • OUG Ireland, Mar 23-24, Dublin*)
  • APEX World, Mar 30-31, Rotterdam*)
  • APEX Connect, May 9-11, Berlin*)
  • KScope, Jun 25-29, San Antonio*)
  • POUG, Sep 1-2, Krakow*)
  • Oracle Open World, Oct 1-5, San Francisco*)
  • SIOUG, Oct 16-17, Portoroz, Slovenia*)
  • HROUG, Oct 17-20, Rovinj, Croatia*)
  • DOAG, Nov 21-23, Nuremberg*)
  • UKOUG Tech17, Dec 4-6, Birmingham*)

  • 2016
  • OUG Ireland, Mar 3-4, Dublin*)
  • APEX World, Mar 7-8, Rotterdam*)
  • APEX Connect, Apr 26-28, Berlin*)
  • BGOUG, Jun 3-5, Borovets*)
  • KScope, Jun 26-30, Chicago*)
  • Oracle Open World, Sep 18-22, San Francisco*)
  • Nordic ACED Tour, Oct 11-13, Copenhagen - Oslo - Helsinki*)
  • DOAG, Nov 15-17, Nuremberg*)
  • UKOUG Tech16, Dec 5-7, Birmingham*)

  • 2015
  • ODTUG Webinar, Feb 13, online*)
  • Riga Dev Day, Jan 22, Riga*)
  • OUG Norway, Mar 12-14, Oslo-Kiel-Oslo*)
  • OUG Ireland, Mar 19, Dublin*)
  • APEX World, Mar 25, Rotterdam(stand)
  • Kscope15, Jun 21-25, Hollywood (FL)*)
  • SIOUG, Oct 12-13, Portoroz, Slovenia*)
  • HROUG, Oct 13-16, Rovinj, Croatia*)
  • Oracle Open World, Oct 25-29, San Francisco
  • UKOUG Tech15, Dec 7-9, Birmingham*)

  • 2014
  • ODTUG Webinar, Feb 13, online*)
  • OUG Ireland, Mar 11, Dublin*)
  • APEX World, Mar 25, Zeist*)
  • OUG Norway, Apr 3 - 5, Oslo-Kiel-Oslo*)
  • APEX Usergroup Düsseldorf, Apr 29*) 
  • OUG Finland, Jun 5-6, Helsinki*)
  • Kscope Preview, Jun 12, Nieuwegein*)
  • ODTUG Kscope, Jun 22-26, Seattle*)
  • Oracle Open World, Sep 28 - Oct 2, San Francisco*)
  • Bulgarian Oracle User Group, Nov 14 - 16, Pravets*)
  • UKOUG Dec 8 - 10, Liverpool*)

  • 2013
  • OUG Ireland, Mar 12, Dublin*)
  • APEX World, Apr 9, Zeist*)
  • OUG Norway, Apr 17 - 19, Oslo-Kiel-Oslo*)
  • ODTUG's Expert Panel APEX, May 14, online*)
  • Planboard, May 28, Oracle NL*)
  • OUG Scotland, June 12, Linlithgow*)
  • ODTUG Kscope, Jun 23 - 27, New Orleans*)
  • ODTUG APEXposed!, Sep 10 - 11, Montreal*)
  • Oracle Open World, Sep 22 - 26, San Francisco*)
  • Bulgarian Oracle User Group, Nov 22 - 24, Plovdiv*)
  • UKOUG, Dec 2 - 4, Manchester*)

  • 2012
  • OUG Ireland, Mar 21, Dublin*)
  • OUG Norway, Mar 22 - 24, Oslo-Kiel*)
  • OUG Holland (OGH) APEX Day, Mar 26, Zeist (NL)*)
  • Collaborate, Apr 22 - 26, Las Vegas (NV)*)
  • Bulgarian Oracle User Group, May 11 - 13, Borovets*)
  • OUG Scotland 2012, Jun 13, Linlithgow*)
  • Oracle Open World 2012, Sep 30 - Oct 4, San Francisco*)
  • UKOUG 2012, Dec 3 - 5, Birmingham*)

  • 2011
  • UKOUG 2011*)
  • DOAG - German Oracle User Group*)
  • Oracle Open World
  • ODTUG Kaleidoscope*)
  • OBUG APEX SIG*)
  • ORCAN User Group*)
  • IOUG Collaborate*)
  • OGH APEX Dag*)

  • 2010
  • UKOUG Conference*)
  • ODTUG's APEXposed*)
  • Oracle Open World*)
  • ODTUG Kaleidoscope*)
  • OBUG APEX SIG*)
  • Oracle APEX symposium Dublin*)
  • IOUG Collaborate*)(canceled due to the volcano eruption in Iceland)
  • OGH APEX Dag*)

  • 2009
  • UKOUG Conference*)
  • Oracle Open World*)
  • ODTUG Kaleidoscope*)

  • 2008
  • UKOUG Conference*)
  • Oracle Open World*)
  • ODTUG Kaleidoscope

  • 2007
  • UKOUG Conference*)

  • 2006
  • Oracle Open World


*) Presenting

Popular posts from this blog

How to create neatly formatted Excel documents using PL/SQL?

If there is a requirement to produce output from an application into Excel, you would probably create a CSV (Comma Separated File) with the data and start Excel to show the data - at least that's what I did...until now. The drawback of this solution is that you could only produce data and no nice layout. But Excel is also capable of opening HTML-files and using this you could create Excel files with data and magnificent layout! Let me give an example: 1. Create a procedure to show the data in formatted in an HTML table. CREATE OR REPLACE PROCEDURE display_emp_list IS v_emp_count NUMBER(5); v_empno NUMBER(8); v_ename VARCHAR2(50); v_job emp.job%TYPE; v_sal emp.sal%TYPE; v_bg_color VARCHAR2(10) := ''; CURSOR c_emp IS SELECT empno, initcap(ename), job, sal FROM emp ORDER BY ename; BEGIN SELECT COUNT(*) INTO v_emp_count FROM emp; owa_util.mime_header('application/ms-excel', FALSE); htp.p('Content...

Refresh selected row(s) in an Interactive Grid

In my previous post I blogged about pushing changed rows from the dabatase into an Interactive Grid . The use case I'll cover right here is probably more common - and therefore more useful! Until we had the IG, we showed the data in a report (Interactive or Classic). Changes to the data where made by popping up a form page, making changes, saving and refreshing the report upon closing the dialog. Or by clicking an icon / button / link in your report that makes some changes to the data (like changing a status) and ... refresh the report.  That all works fine, but the downsides are: The whole dataset is returned from the server to the client - again and again. And if your pagination size is large, that does lead to more and more network traffic, more interpretation by the browser and more waiting time for the end user. The "current record" might be out of focus after the refresh, especially by larger pagination sizes, as the first rows will be shown. Or (even wors...

APEX ReadOnly Pages - The easy way

If your Oracle APEX Application requires different types of access - full access or readonly - for different types of users, you can specify a Read Only Condition on Page level (or Region, Item, Button, etc.).  You can set an Authorization Scheme on Application level, so it'll be applied to all pages. So if you have an Authorization Scheme named 'User Can Access Page' defined by a PL/SQL function like this: return apex_authorization.user_can_access_page ( p_app_id  => :APP_ID , p_page_id => :APP_PAGE_ID , p_user    => :APP_USER );  then you can code all the logic in the database using the APEX Repository, your own tables or a combination to define whether a user has access to that page or not. But alas it is not possible to define something similar Application wide for a Read Only condition. You can specify an Authorization Scheme 'User has Read Only Access' using a similar signature as the one above and use that on each and e...