Nach Markierungen suchen

Polymorphic Table Functions (PTF) , Part 1 – Basics

I have already posted some examples on Polymorphic Table Functions in Oracle 18c in the last months. I quickly realized how difficult it is to explain completely new feature using advanced examples and wanted to write a series of posts starting from very...

Veröffentlicht 19 Aug 2018 23:28 von triBLOG

Gespeichert unter: SQL, Oracle, Trivadis, PL/SQL, PTF, 18c, polymorphic table function

View-API for JOOQ Application

In this blog post I show how to build a read-only view-API for Oracle’s HR sample schema. And I will use this view-API in a JOOQ application. This […] The post View-API for JOOQ Application appeared first on Philipp Salvisberg's Blog . ...read...

Veröffentlicht 5 Aug 2018 22:34 von triBLOG

Gespeichert unter: Oracle, PL/SQL, Oracle 12c, jOOQ, oddgen, PinkDB

The Pink Database Paradigm (PinkDB)

1. Introduction The Pink Database paradigm (PinkDB) is an application architecture for database centric applications. It is focusing on relational database systems and is vendor neutral. […] The post The Pink Database Paradigm (PinkDB) appeared first...

Veröffentlicht 18 Jul 2018 19:53 von triBLOG

Gespeichert unter: SQL Server, SQL, Oracle, PL/SQL, MySQL, postgresql, Oracle 18c, SmartDB, PinkDB, Teradata, HSQL, EnterpriseDB, MariaDB, Db2

Is Your Application SmartDB?

I had recently a few discussions regarding the Smart Database Paradigm (SmartDB) with long-standing customers, new customers, partners, competitors and colleagues. Some people think that using […] ...read more...( read more ) Mehr…

Veröffentlicht 18 Jul 2018 19:52 von triBLOG

Gespeichert unter: SQL, Oracle, PL/SQL, Oracle 12cR2, SmartDB, phs

MemOptimized RowStore in Oracle Database 18c

The MemOptimized RowStore introduced in Oracle Database 18c is designed to improve performance of simple queries accessing data via primary key columns only. An example of […] ...read more...( read more ) Mehr…

Veröffentlicht 10 Jun 2018 1:40 von triBLOG

Gespeichert unter: SQL, Oracle, PL/SQL, Oracle 18c, SmartDB

Why and How Using the accessible_by_clause?

The accessible_by_clause was introduced in Oracle Database 12 Release 1 and extended in Release 2. If you do no know this feature, I suggest to have […] ...read more...( read more ) Mehr…

Veröffentlicht 6 Mai 2018 12:22 von triBLOG

Gespeichert unter: Oracle, PL/SQL, Oracle 12c, Oracle 12cR2, accessible_by_clause, utPLSQL

White Listed PL/SQL Programs in Oracle Database 18c

I’ve recently installed plscope-utils in an Oracle Database 18c instance. A package body using the SYS.UTL_XML.ParseQuery function failed to compile. The error message was: PLS-00306: wrong number or […] ...read more...( read more ) Mehr…

Veröffentlicht 30 Apr 2018 18:10 von triBLOG

Gespeichert unter: SQL, Oracle, PL/SQL, Oracle 12c, Oracle 12cR2, Oracle 18c

Oracle Database Security For Developers

The last blog post of Jeff Smith (18.1 Features: SQL Injection Detection) about little, but nice feature of SQL Developer detecting if your PL/SQL code might be vulnerable for SQL Injection, reminded me about the presentation I’ve delivered during...

Veröffentlicht 10 Apr 2018 15:30 von triBLOG

Gespeichert unter: Oracle, Security, PL/SQL, SQL injection

Polymorphic Table Functions Example – (NOT) Transposing Rows to Columns

It was not possible for me to write a follow-up to my last post about Transposing Columns To Rows with PTF showing an opposite task of transposing rows to columns right next weekend as I thought. Partly because of our awesome Trivadis TechEvent which...

Veröffentlicht 4 Apr 2018 12:58 von triBLOG

Gespeichert unter: SQL, Oracle, Trivadis, PL/SQL, Pivot, PTF, 18c, transponieren, UNIVOT, "table function", tabellenfunktion, polymorphic

PL/SQL Cop for SonarQube 7.0

The last two months my Trivadis colleague Daniel Schutzbach and I have been working on the PL/SQL Cop plugin for SonarQube. The goal was to support […] ...read more...( read more ) Mehr…

Veröffentlicht 11 Mrz 2018 18:51 von triBLOG

Gespeichert unter: Oracle, PL/SQL, PL/SQL Cop, SonarQube

How to Prove That Your SmartDB App Is Secured Against SQL Injection Attacks

If you are guarding your data behind a hard shell PL/SQL API as Bryn Llewellyn, Toon Koppelaars and others are proclaiming, then it should be quite easy […] ...read more...( read more ) Mehr…

Veröffentlicht 17 Dez 2017 0:46 von triBLOG

Gespeichert unter: Oracle, PL/SQL, Oracle 12cR2, PL/Scope

Entity Relationship Model for PL/Scope

Today I found a sketch of an ERD from last year when looked at the new features of PL/Scope in version 12.2. It looked a bit […] ...read more...( read more ) Mehr…

Veröffentlicht 15 Okt 2017 15:58 von triBLOG

Gespeichert unter: Oracle, PL/SQL, Oracle 12cR2, PL/Scope

Limitations of PL/Scope and How to Deal with Them

My first car was a Renault R5 TX. The motor cooling of this car was really bad. On a hot summer day it was simply not […] ...read more...( read more ) Mehr…

Veröffentlicht 14 Okt 2017 17:23 von triBLOG

Gespeichert unter: Oracle, PL/SQL, Oracle 11g, Oracle 12cR2, PL/Scope

ODC Appreciation Day: Cursor Variables

You know everything is Tim Hall s fault, right? Including this blog post? Oh yes it is, he came up with the idea of OTN ODC Appreciation Day - a day where Oracle Bloggers all over the world show their appreciation of the Oracle Developer Community by...

Veröffentlicht 9 Okt 2017 21:44 von triBLOG

Gespeichert unter: PL/SQL, TVD

Avoiding reinventing the wheel - use MULTISET EXCEPT to get set relative complement

Today in an application I stumbled upon a PL/SQL function created to return those elements of one nested table that did not exist in another nested table. Not a huge function, but still a bit of work and some thinking that had been done some while ago...

Veröffentlicht 28 Sep 2017 15:19 von triBLOG