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
Category Archives: Oracle 12C New Features
Install Oracle in silent mode 12C Release 1 (12.1) on OEL7
This article presents how to install Oracle 12C(12.1) Release 1 on Oracle Enterprise Linux 7 (OEL7) in silent mode.
Enhanced LEFT OUTER JOIN syntax Oracle Database 12C release 1 (12.1)
In 12C LEFT OUTER JOIN is enhanced so a single table can be the null-generated table for multiple tables
Installation of Oracle R Enterprise Client 1.5 for Oracle Database 12C on OEL6
This presentation shows how to install and configure Oracle R Enterprise Client 1.5 for Oracle Database 12C Linux OEL6.
Architecture
Following picture shows general architecture of Oracle R. This article will focus only on installation of Client parts.
Installation of Oracle R Enterprise Server 1.5 on Oracle Database 12C on OEL6
This presentation shows how to install and configure Oracle R Enterprise Server 1.5 on Oracle 12C Linux OEL6.
Architecture
Following picture shows general architecture of Oracle R. This article will focus only on installation of Server parts.
Install Oracle 12C Release 1 (12.1) on Fedora 24
This article presents installation of Oracle database 12C(12.1) on Fedora 24. Read following article to install Fedora 24 Linux: Install Fedora 24(for comfort set 4G memory for your virtual machine). Continue reading
Enhanced PL/SQL Only Data Types in PL/SQL-to-SQL Oracle Database 12C release 1 (12.1)
New improvements are available in Oracle Database 12c for PL/SQL-only data types.
It is possible to bind values with PL/SQL-only data types
- to anonymous blocks (which are SQL statements)
- PL/SQL function calls in SQL queries and CALL statements
- the TABLE operator in SQL queries.
Enhanced Online DDL Capabilities Oracle Database 12C release 1 (12.1)
This article presents enhanced DDL capabilities in Oracle 12C
It’s possible to use ONLINE keyword to allow execution of DML statements during the following DDL operations:
- SET COLUMN UNUSED
- ALTER INDEX UNUSABLE
- DROP INDEX/CONSTRAINT
Install Oracle 12C Release 1 (12.1) on Fedora 23
This article presents installation of Oracle database 12C(12.1) on Fedora 23. Read following article to install Fedora 23 Linux: Install Fedora 23(for comfort set 4G memory for your virtual machine). Continue reading
UTL_CALL_STACK Oracle Database 12C release 1 (12.1)
New package UTL_CALL_STACK is added in Oracle 12C. The package gives more control for format display of call stack, error stack and error backtrace.
CALL STACK – it’s showing call stack from where it was started to where the call stack was examined. In previous release DBMS_UTILITY.FORMAT_CALL_STACK could be used to display it in constant format.
ERROR STACK – it shows full oracle error chain. In previous release DBMS_UTILITY.FORMAT_ERROR_STACK could be used to display it in constant format.
ERROR BACKTRACE – The backtrace is a trace from where the exception was thrown to where the backtrace was examined. In previous release DBMS_UTILITY.FORMAT_ERROR_BACKTRACE could be used to display it in constant format.