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.
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.
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
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.
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.
apex_5.0.X.zipto 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
It’s recommended to do backup of the database and disable the Oracle XMLDB HTTP server by setting the HTTP port to 0.