(Oren Nakdimon) When solving Kakuro it is essential to know for a given integer X and a given number of elements N all the combinations of N non-repeating digits [1-9] that their sum equals to X.
Tag: Oracle
Oracle USERENV Function with Examples
(Ben) The Oracle USERENV function allows you to get information about the current session. Learn how to use the USERENV function in this article.
Scripted Domain Creation for SOA/BPM, OSB 12.2.1
(Martien van den Akker) Recently I blogged about the automatic install of SOASuite and ServiceBus 12.2.1. It catered for the installation of the binaries and the creation of a repository.
Parsing … no big deal eh ?
(connormcdonald) Most of us have probably seen the standard demo when it comes to emphasizing the need for sharable SQL, aka, using bind variables where appropriate.
Oracle Database 11g: Virtual columns
(Maarten Smeets) Views in the Oracle database have several uses. You can use them to provide a view of data in different tables as a single object to query. You can use views to achieve a virtualization layer. Also views can be used to provide a user specific view of data. Implementing views however
12c FETCH PERCENT
(connormcdonald) A nice little feature in 12c is the FETCH FIRST n ROWS syntax, which is a simple shorthand to avoid using inline views and the like to get a subset of the rows from what would normally be a larger resultset.
ARCHIVE_LAG_TARGET on Oracle 11.2.0.4
(Andrew Reid) I read about this parameter, which is supposed to force a redo log switch after a certain number of seconds. I decided to try it out in an Oracle 11.2.0.4 database. This is the record from the alert log showing me setting the parameter:
Create a Navigation Bar based on a SQL statement
(Roel Hartman) Creating a Navigation Bar using static values is very straightforward. Just create a list similar to this example below – and you can easily define multiple levels.
Tutorial: Using Oracle EBS Adapter in Integration Cloud Service
(Rekha Ayothi) Oracle Integration Cloud Service (ICS) is Oracle’s integration Platform as a Service (iPaaS). It provides a web-based interface to integrate Software as a Service (SaaS) and on-premise applications. It includes various technology and application adapters.
User Defined Target Properties
(raysmithace) We can create our own target property classifications using EM CLI. In this example we’ll create a new property named “Product Type”. In my shop we’ll use that property to identify Oracle RAC and single instance databases, but also noSQL targets that we’re adding to our EM environmen
