(Martien van den Akker) Earlier I wrote about the automatic installation of Fusion Middleware components using response files. A thing that lacked in my scripts was that although I had a FMW_HOME variable set in my enviroment shell script, the response files had the location hard coded in them.
Tag: Oracle
New PL/SQL pragma (12cR2) to deprecate program units – sign of a modern programming language
(Lucas Jellema) Bryn Llewellyn (Distinguished Product Manager, Database Division, Oracle) presented at OOW2016 on new features in PL/SQL in Oracle Database 12cR2. One of the features that stood out was a new pragma deprecate that can be added to program units such as functions and procedures inside
Video Tutorial: XPLAN_ASH Active Session History – Part 12
(Randolf Geist) The final part of the video tutorial explaining the XPLAN_ASH Active Session History functionality continuing the actual walk-through of the script output.
Formatter Improvements in v4.2
(Jeff Smith) The old formatter, the code that’s used to format your code from v1 to version 4.1 was based on some pattern matching code and expressions. It was very limited, and didn’t like a lot of syntax and coding styles common in Oracle code.
Oracle Process Cloud Service advanced form validation and control
(Patrick Sinke) In my previous blogpost I explained how forms in PCS are created and what basic options are available. Now I would like to go deeper into the details of rules and business objects.
Datapump Does not Export Permissions on Objects Owned by SYS
(Andrew Reid) I was reminded recently that Datapump does not export permissions on objects owned by SYS so I decided to write a post about it for my blog. It was tested on an Oracle 11.2.0.1 database. First I created a user called USER1:
Creating and editing forms in Process Cloud Service
(Patrick Sinke) Oracle Process Cloud Service is a PaaS (Platform as a Service) offering which centers around designing and managing (stand alone) business processes in the cloud. The focus is once again on business analysts and other non-technical people to automate business processes.
Extending Oracle SQL Developer Command Line (SQLcl) with JavaScript: Single Record Viewer
(Jeff Smith) Oracle SQL Developer Command Line (SQLcl) is the full name for what we’ve been calling, SQLcl.
Oracle 12c In-memory Column Store Has An Unexpected Surprise
(David Fitzjarrell) Oracle 12.1 provides an interesting performance enhancement, the in-memory column store, that can increase performance by reducing physical I/O load by making tables memory-resident (to simplify the description somewhat).
Using Oracle 12c with Pivotal Cloud Foundry Applications and Spring Boot
(Pas Apicella) In this post I walk through what it would take to access Oracle 12c using a spring boot application deployed to Pivotal Cloud Foundry PCF all from my Macbook Pro.
