Nach Markierungen suchen

Polymorphic Table Functions (PTF) , Part 3 – Row Replication

In the third part of the PTF-series we learn how a PTF can change the cardinality of the input data flow: return more or less rows as in the input. We’ll use the same simple table as in the part 2 and our new task will be column transposing. We’ll...

Veröffentlicht 12 Nov 2018 22:37 von triBLOG

Gespeichert unter: SQL, Oracle, Trivadis, PL/SQL, PTF, 18c, row repliaction

Polymorphic Table Functions (PTF) , Part 2 – More Basics With Some Deep-Dive

In the first part of PTF series we went through a very basic example removing some columns and adding a new column with a constant value. Starting from the same example we’ll do something more meaningful in the second part. How about concatenating...

Veröffentlicht 29 Okt 2018 16:47 von triBLOG

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

Polymorphic Table Functions (PTF) – Tinkering with Rowsets

Writing the second „basics“ post on PTF I discovered, that there were much more details worth mentioning, than it would be acceptable for a „basics“ post and would blow it up anyway So I decided to to separate the tests and finding...

Veröffentlicht 29 Okt 2018 16:45 von triBLOG

Gespeichert unter: SQL, Oracle, Trivadis, PL/SQL, PTF, 18c, polymorphic table functions, row set, rowset

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