Nach Markierungen suchen

Using DBMS_DEBUG in SQL Developer

Do you need to debug PL/SQL units in SQL Developer? You can’t get it to work because someone refuses to open TCP ports between your database […] The post Using DBMS_DEBUG in SQL Developer appeared first on Philipp Salvisberg's Blog . ...read...

Veröffentlicht 8 Apr 2019 0:28 von triBLOG

Gespeichert unter: Oracle, PL/SQL, Debugging, SQL Developer

MemOptimized RowStore in Oracle Database 19c

Since February, 13 2019 Oracle Database 19c is available. I blogged about this feature here and here. Time for an update. So, what’s new in 19c regarding the […] The post MemOptimized RowStore in Oracle Database 19c appeared first on Philipp Salvisberg's...

Veröffentlicht 17 Feb 2019 21:15 von triBLOG

Gespeichert unter: SQL, Oracle, PL/SQL, PinkDB, oracle 19c

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

Blogs

Sponsored by

Syndication

Recent Posts

Tags

Archives