In 12C LEFT OUTER JOIN is enhanced so a single table can be the null-generated table for multiple tables
Enhanced LEFT OUTER JOIN syntax Oracle Database 12C release 1 (12.1)
Reply
Category Archives: Oracle 12C New Features
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.
Install Oracle 12C Release 1 (12.1) on Fedora 22
This article presents installation of Oracle database 12C(12.1) on Fedora 22.
Read following article to install Fedora 22 Linux: Install Fedora 22(for comfort set 4G memory for your virtual machine).
Install and configure Apex 5.0.X embedded PL/SQL
This article presents how to install and configure Apex for version 5.0.X for Oracle 11G
Prepare software to installation
Download installation package from Oracle site and unzip.
Download apex_5.0.X.zip to directory /tmp and unzip it from
http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html
cd /tmp
unzip <downloaded software>
After unzip is completed a new directory will be created /tmp/apex so go to this directory and log into database as SYSDBA. Always use SYSDBA account for running all scripts.
cd /tmp/apex sqlplus / as sysdba
Pre-installation steps
It’s recommended to do backup of the database and disable the Oracle XMLDB HTTP server by setting the HTTP port to 0.
EXEC DBMS_XDB.SETHTTPPORT(0);