(Ben) The Oracle TO_DATE function is one of the most common and useful string manipulation functions in Oracle, but it can be confusing. I’ll explain how to use the TO_DATE function in this article.
(Dbaharrison) Now if you’ve read a few of my blog posts over the past few years you’ll know i have an ongoing hate/hate relationship with anything to do with charactersets.
(Hemant K Chitale) Building on a previous blog post (you could read it before or after this post), here’s a quick demo of a caveat or quirk with V$RMAN_BACKUP_JOB_DETAILS.
(Brendan Tierney) If you are a user of the Oracle Data Miner tool (the workflow data mining tool that is part of SQL Developer), then you will have noticed that for many of the algorithms you can specify a Case Id attribute along with, say, the target attribute.
(Kris Rice) I saw Stephen’s example of checking reserved words in the database from Vertan’s day and figured I’d do the same in SQLcl.
(David Fitzjarrell) Oracle provides two parameters that affect the PGA that look very similar but operate very differently. One of these parameters is the well-known pga_max_size and the other is a hidden parameter, _pga_max_size.
(Christian Antognini) Before describing the issue that lead to this post, let’s shortly review how the handling of initialization parameters works in a multitenant environment.
(Ben) In this article, I’ll explain what the Oracle CHARTOROWID function is and show you an example.
(cj) Want a fast way to spool CSV or JSON from Oracle Database? Check out the new SQL*Plus 12.2 SET MARKUP CSV option and the new Oracle Database 12.2 JSON_OBJECT operator.
(Andrejus Baranovskis) ADF Faces LOV component can be easily enabled with auto suggest functionality.