Skip to Main Content
ACE Program
ACE Directory
Become an ACE
ACE Sign In
ACE
Full Name
Erik Van Roon
Full Name
ACE Associate
Top Level Details
Job Role
Database Developer
Company
EvROCS
Country
Netherlands
Top Expertise
Database
Focus Area
Database
About Erik
In 1995 Erik van Roon switched careers for medical reasons from Microbiology/Biochemistry to being an Oracle Developer. Since then he has worked for several consulting companies in the Netherlands. Since 2009 he is self-employed. His company is called EvROCS, short for Erik van Roon Oracle Consulting Services. He has worked on major projects for several clients in industries like entertainment, banking and energy, working with the โclassicโ Oracle tools Designer, Forms, Reports, and of course SQL and PLSQL. He has been the technical lead of multiple successful high impact data-migration projects moving and transforming large amounts of data. In 2012 he started speaking at international conferences and since then has been a speaker at many in person and online events. He is a board member of community support program [Symposium42](https://sym42.org/), and is a co-founder and core-team alumni of the [MASH program](https://mashprogram.wordpress.com/) which assists people who want to become a public speaker by supplying them an experienced speaker as a mentor.
Expertises
Database
SQLcl
Home Page
https://www.evrocs.nl/?lang=en
Oracle Community
https://community.oracle.com/tech/developers/profile/Erik%20van Roon
Links
Latest Contributions
#SELECTION#
#ICON_HTML#
If you have a problem, if no one else can help, and if you can find them, you can use the profilers
Dec 02, 2025 - Presentation - in-person or virtual - UKOUG 2025
Oracle PL/SQL
Performance
#ACTIONS#
#SELECTION#
#ICON_HTML#
Zooming in on macros
Nov 05, 2025 - Presentation - in-person or virtual - EMEA Community Tour 2025
#ACTIONS#
#SELECTION#
#ICON_HTML#
''I don't need SQLcl, I have SQLPlus.'' You're wrong.
Nov 05, 2025 - Presentation - in-person or virtual - EMEA Community Tour 2025
#ACTIONS#
#SELECTION#
#ICON_HTML#
Zooming in on macros
Nov 03, 2025 - Presentation - in-person or virtual - EMEA Community Tour 2025
#ACTIONS#
#SELECTION#
#ICON_HTML#
Speeding up executions of userdefined functions in SQL
Oct 31, 2025 - Presentation - in-person or virtual - EMEA Community Tour 2025
#ACTIONS#
#SELECTION#
#ICON_HTML#
Speeding up executions of userdefined functions in SQL
Oct 28, 2025 - Presentation - in-person or virtual - EMEA Community Tour 2025
Oracle SQL
Performance
Oracle PL/SQL
#ACTIONS#
#SELECTION#
#ICON_HTML#
Speeding up executions of userdefined functions in SQL
Oct 27, 2025 - Presentation - in-person or virtual - EMEA Community Tour 2025
Oracle SQL
Performance
Oracle PL/SQL
#ACTIONS#
#SELECTION#
#ICON_HTML#
Zooming in on macros
Oct 16, 2025 - Presentation - in-person or virtual - HrOUG 2025
Oracle SQL
#ACTIONS#
#SELECTION#
#ICON_HTML#
If you have a problem, if no one else can help, and if you can find them, you can use the profilers
Sep 05, 2025 - Presentation - in-person or virtual - POUG 2025
Oracle PL/SQL
Performance
#ACTIONS#
#SELECTION#
#ICON_HTML#
Scripting in SQLcl - You can never have enough of a good thing
May 22, 2025 - Presentation - in-person or virtual - ITOUG 2025
Oracle SQLcl
JavaScript
SQLcl
#ACTIONS#
#SELECTION#
#ICON_HTML#
Zooming in on macros
May 13, 2025 - Presentation - in-person or virtual - APEX Connect 2025
Oracle SQL
#ACTIONS#
1 - 11