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

 

Home

Print
11
Jun

Select into statements..

Written by Richard Weug on Monday, 11 June 2012 08:50. Posted in PL/SQL

One thing that bothers a lot of PL/SQL developers is when they have to select some data from a table into local variables. The problem is that the data may or may not exist (i.e. return 0..1 rows). They're several ways to write this code, some taking longer than others which is the pain point for developers.

Print
04
Jun

NTH Value windowing

Written by Richard Weug on Monday, 04 June 2012 09:05. Posted in PL/SQL

In my previous post which highlighted some analytic functions, I mentioned that the windowing clause must be explicitly defined when using the NTH_VALUE function. To recap, here's the example I used for NTH_VALUE which lists the 2nd highest salary for each department:

Print
29
May

Interesting Analytical Functions

Written by Richard Weug on Tuesday, 29 May 2012 09:44. Posted in PL/SQL

I had to write some reports for a personal application of mine last night and needed to expand beyond my usual set of analytic functions that I normally use. I thought it would be a good idea to do a quick blog post on these analytic functions.

Print
29
May

Flashback

Written by Richard Weug on Tuesday, 29 May 2012 09:40. Posted in Tips and Tricks

The Flashback Query feature of Oracle (10g) can be really helpful when you run that UPDATE or DELETE statement and then, after the COMMIT, you discover that you made a mistake!

Wouldn't it be nice to be able to look back and see what the data looked like before you messed things up? With a Flashback Query you can do just that:

Print
23
May

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,..