APEXblog.nl - Tips and Tricks

About This Blog:
I (Richard Weug) started this blog primary for myself to save all kinds of Apex tips and tricks in one place. To use it as a place to write down how I used some coding in my own projects, but also to copy and paste all kinds of articles I find on the Internet. (So I never have to wonder on what website did I read about??? When I see something interesting I collect the content so I have my own archive/knowlegde base.

View my profile on LinkedIn


PL/SQL stuff


Using a comma-separated list in an SQL query

Written by Richard Weug on Wednesday, 23 May 2012 13:51. Posted in PL/SQL

Dit artikel gaat over het gebruik van de IN Operator,..


Apex Collections

Written by Richard Weug on Wednesday, 23 May 2012 09:19. Posted in PL/SQL

Where do you want to hard-code your information?  Somewhere pieces of data need to be written down for reference. They could be in a table; in some variables; within the query itself... there would be quite a few possibilities, regardless of the scenario.

Consider this statement:

select * from my_table where my_col IN ('CODE_1', 'CODE_2', 'CODE_3')

Fun with dates

Written by Richard Weug on Wednesday, 16 May 2012 09:00. Posted in PL/SQL

Here I'm just listing some fun with dates, either from single row sql expressions or cool little queries.


Find in all ALL_VIEWS

Written by Richard Weug on Monday, 07 May 2012 10:22. Posted in PL/SQL

Quite some time ago when I first started blogging I wrote a post regarding limitations on searching the ALL_VIEWS dictionary view.

Simply put, if you would like to run a query such as this to find those views that contain the text "booking_no", you're not going to get very far


Changes in sending email

Written by Richard Weug on Friday, 27 April 2012 10:00. Posted in PL/SQL

Sending e-mails from within the Oracle database using the UTL_MAIL PL/SQL package used to be quite easy in Oracle 10g. However, in Oracle 11gR2, things have changed. Environment: Oracle database, Oracle Linux 6.2