plsql - AMIS Oracle and Java Blog

Browsing: plsql

Database

July 18, 2017 0 Machine Learning in Oracle Database – Classification of Conference Abstracts based on Text Analysis

Machine Learning is hot. The ability to have an automated system predict, classify, recommend and even decide based on models…

December 23, 2016 1 Executing command line scripts from the Oracle Forms client – using WebUtil

Our challenge: we are building the new ERP system – a pure HTML5 browser based application in Oracle ADF. This…

November 2, 2016 0 The state of the flagship as per Oracle OpenWorld 2016 – Oracle Database 12c Release 2, Exadata Express Cloud Service, SQL and PL/SQL

The new 12cR2 release of Oracle Database had already been announced and discussed at length over the past year. And…

September 25, 2016 0 New PL/SQL pragma (12cR2) to deprecate program units – sign of a modern programming language

Bryn Llewellyn (Distinguished Product Manager, Database Division, Oracle) presented at OOW2016 on new features in PL/SQL in Oracle Database 12cR2.…

September 5, 2016 1 One of the many nice new features in 12c database: code based access control

Topic of this blog is a nice new feature in 12c, not the plsql package I built that’s using it.…

June 7, 2016 1 AMIS25 Beyond the Horizon Conference – Session Resource Repository

Below you will find an overview of all the sessions that took place at the AMIS25 Beyond the Horizon conference…

PL/SQL

April 20, 2016 4 Parse JSON Array in SQL and PL/SQL – turn to a Nested Table

Transferring data between technologies and application tiers is done using various formats – binary, native on the one hand and…

November 18, 2015 0 Reflections after Oracle OpenWorld 2015 – Data Management (Database)

This article gives an overview of some of the most eye catching stories from Oracle OpenWorld 2015 around Data Management.…

September 2, 2015 0 Time is of the essence – The Fourth Dimension in Oracle Database 12c (on Flashback and Temporal Database)

Time has always been an important dimension for data in any database with topics like when was data created, when…

May 13, 2015 4 Publish a REST service from PL/SQL to handle HTTP POST requests – using the embedded PL/SQL gateway

Oracle Database can act as an HTTP server – using the Embedded PL/SQL Gateway (the 10g successor of the MOD_PLSQL…

May 11, 2015 8 Invoke a REST service from PL/SQL – make an HTTP POST request using UTL_HTTP in Oracle Database 11g XE

This article is small and simple. It discusses how from PL/SQL an HTTP POST request can be made to a…

April 16, 2015 0 Donderdag 16 april/Thursday April 16th – Speedy Joe’s – Using asynchronous interaction in Java EE to turn the world’s slowest restaurant into a super performant place

De Java SIG (Special Interest Group) van AMIS organiseert op donderdag 16 april een bijeenkomst (publiek toegankelijk) over asynchrone interacties…

March 8, 2015 0 Set values for bind parameters in a database view using application context – single round-trip context manipulation and querying

While writing an article on database session context for the OTech Magazine’s Spring issue, I tried out whether I can…

October 3, 2014 0 Everything That Is Really Useful in Oracle Database 12c for Application Developers – Oracle OpenWorld 2014

A few days ago, I presented a session at Oracle OpenWorld 2014 about the most useful features for application developers…

October 1, 2014 15 FTPS with PL/SQL

Doing a FTP-job with PL/SQL is not difficult. A basic implementation of RFC 959 can be written in a few…

June 25, 2014 0 SQL: combine inline PL/SQL function with inline view in Oracle Database 12c SQL Query

Oracle Database 7.3 was the first to support inline views – using the select * from (select * from) syntax.…

Oracle

June 5, 2014 0 Notes from Finland – impressions from the OUGF 2014 Harmony Conference

I am currently attending the OUGF 2014 Harmony Conference in a beautiful setting on a Finnish lakeside. This conference has…

AMIS

November 20, 2013 1 Steven Feuerstein Master Class. Anti-Pattern PL/SQL Programming + 12c New PL/SQL Features, December 12 and 13 2013

12 and 13 December 2013 AMIS will host a two day masterclas with Oracle PL/SQL guru Steven Feuerstein. The Design…

PL/SQL

October 17, 2013 2 Solving PLS-00753: malformed or corrupted wrapped unit within Apex SQL Workshop

I was working on this great Apex plugin to load Excel sheets with more than 50 columns into the database.…

August 2, 2013 0 AMIS presenteert: twee-daagse masterclass PL/SQL 12c door Steven Feuerstein

Steven Feuerstein, dé PL/SQL autoriteit, komt op 12 en 13 december naar AMIS in Nieuwegein. Twee dagen lang verzorgt hij…

1 2 3 4 Next