This article presents how to install Oracle 12C(12.2) Release 2 on Oracle Enterprise Linux 7 (OEL7).
Read following article how to install Oracle Enterprise Linux 7: Install Oracle Linux 7 (OEL7) (for comfort set 4G memory for your virtual machine before proceeding with Oracle software installation).
Software for 12CR2 is available on OTN or edelivery
In previous releases there was always problem with function LISTAGG. If list of concatenated expression exceeds maximum length supported by VARCHAR2 type, then ORA-01489 is raised.
In new version Oracle Database Release 12.2 addressed this issue by adding extra clause ON OVERFLOW TRUNCATE to hide this error. In my opinion it’s not full solution but in some cases can be useful.
LISTAGG ( [ALL] <measure_column> [,<delimiter>]
[ON OVERFLOW TRUNCATE [truncate_literal] [WITH | WITHOUT COUNT] |
ON OVERFLOW ERROR])
WITHIN GROUP (ORDER BY <oby_expression_list>)
I recommend to read following article as well:
String concatenation aggregation methods
New function VALIDATE_CONVERSION has been introduced in Oracle Database Release 12.2.It determines wether a given expression can be converted to the requested data type. It can return:
- 1 – if conversion is possible or expression evaluates to NULL
- 0 – if conversion is not possible
- Error is expression returns error
CAST function in release 12.2 enables to add error handler DEFAULT return_value ON CONVERSION ERROR in case conversion fails.
New release 12.2 introduces possibility to generate long identifiers up to 128 characters for name like tables, views, triggers, columns and so on. In previous release it was limited to 30 characters.
This article presents installation of Oracle database 12C(12.1) on Fedora 25. Read following article to install Fedora 25 Linux: Install Fedora 25(for comfort set 4G memory for your virtual machine). Continue reading
This article presents how to install Oracle 12C(12.1) Release 1 on Oracle Enterprise Linux 7 (OEL7) in silent mode.
In 12C LEFT OUTER JOIN is enhanced so a single table can be the null-generated table for multiple tables
This presentation shows how to install and configure Oracle R Enterprise Client 1.5 for Oracle Database 12C Linux OEL6.
Following picture shows general architecture of Oracle R. This article will focus only on installation of Client parts.
This presentation shows how to install and configure Oracle R Enterprise Server 1.5 on Oracle 12C Linux OEL6.
Following picture shows general architecture of Oracle R. This article will focus only on installation of Server parts.