Nach Markierungen suchen

ORA-22905 when calling ODCI Table functions from PL/SQL

Back in 2015 I experimented using ODCITable* functions to dynamically parse delimited text (see blog post here .) Now blog reader Daniel Cabanillas points out, that it raises an error when used in PL/SQL. Silly me - I had only tried it out in SQL (my...

Veröffentlicht 14 Jan 2019 22:27 von triBLOG

Gespeichert unter: SQL, PL/SQL, TVD

Dynamic Pivot with Polymorphic Table Function?

LiveSQL is great place to start playing with new features. It provides a couple of very helpful demo scripts explaining how polymorphic table functions work. There I found a new script few days ago which uses PTF for dynamic pivot! WOW! According to my...

Veröffentlicht 4 Jan 2019 14:24 von triBLOG

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

Polymorphic Table Functions (PTF), Part 4 – Table Semantic PTF

In the first three parts of the series we have seen how a PTF basically works, but we have focused on row-semantic PTF only. In this part we’ll look at the table semantic PTF. As a reminder, the main difference to row-semantic PTF is that it is...

Veröffentlicht 24 Dez 2018 14:47 von triBLOG

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

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

Blogs

Sponsored by

Syndication

Recent Posts

Tags

Archives