Blog: Alex Nuijten

211 blogs updated: 12 min. ago
ODC Appreciation Day - Comparing JSON, they thought of everything...
Oracle 12c introduced JSON in the database and one of the most recent additions is a function to compare JSON, JSON_EQUAL. From the document...
11-10-2018 10:30:48 Alex Nuijten Oracle
JSON, BLOB column and Check Constraint
Last week I attended Neil Chandler's session on JSON during the POUG conference in beautiful Sopot, Poland. The JSON Developer's Guide recom...
11-09-2018 10:43:45 Alex Nuijten Oracle
JSON_TABLE and the Top 2000
Oracle database 12c provides native JSON parsing. It is relatively easy to go from data in a JSON format to a relational representation. In ...
09-01-2018 15:17:57 Alex Nuijten Oracle
ODC Appreciation Day: EMP #ThanksODC
Here is my very short entry for the Oracle Developer Community Appreciation Day 2017.Very often I use the good ol' EMP table to demonstrate ...
10-10-2017 22:40:56 Alex Nuijten Oracle
Wanted New Speakers
Yesterday there was an email coming from the UK Oracle User Group (UKOUG) about their upcoming Tech conference at the end of the year. There...
01-06-2017 14:41:51 Alex Nuijten Oracle
Good old BIN_TO_NUM to check the overall status
A good while ago Chris Saxon, member of the AskTom answer team, asked on twitter which datatype you use when defining tables when you need a...
28-03-2017 10:43:50 Alex Nuijten Oracle
Generate Rows based on a Column Value
My requirement is the following: In a database table the activity, start time and the number of repetitions is stored, but for the report th...
20-03-2017 11:56:45 Alex Nuijten Oracle
APEX: Display the Page Alias on every page - without modifying the Template
Having a Page Alias shown on the page can make communication with your end users a little bit easier. Instead of directing them to the URL a...
03-01-2017 10:23:16 Alex Nuijten Oracle
OTN Appreciation Day: Analytic Functions
This is my contribution to the OTN Appreciation Day, which was initiated by Tim Hall. One of my favorite features of the Oracle Database are...
11-10-2016 09:03:10 Alex Nuijten Oracle
Iconic Breadcrumbs in APEX
Normally when you use a Breadcrumb in an APEX application you enter the data and that's it. The breadcrumb will look something like this: Or...
07-10-2016 15:36:11 Alex Nuijten Oracle

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.