SharePointCommunity

Die deutschsprachige Community für SharePoint, Microsoft 365, Teams, Yammer und mit Azure

Anmelden | Beitreten | Hilfe

SharePoint Mirror » Alle Tags » PL/SQL (RSS)

Nach Markierungen suchen

Blogs

SharePoint Mirror

Home

Syndication

RSS
Atom
Kommentar-RSS
E-Mail-Aktualisierungen empfangen
Abonnieren

Archives

How to Save 7 Keystrokes with dbms_xplan

An almost unknown simplification in the usage of dbms_xplan is possible since Oracle 12.2. Sometimes, there are small details that makes our job (a little bit) easier. In one of his presentations at the Kscope19 conference, Kim Berg Hansen mentioned an...

Veröffentlicht 16 Jul 2019 22:22 von triBLOG

Gespeichert unter: Oracle, Performance, PL/SQL, Oracle 12c
Running utPLSQL Tests in SQL Developer

Introduction In November 2017 Jacek Gebal asked me if I could help to integrate utPLSQL into SQL Developer. In January 2018 we released the first MVP. […] The post Running utPLSQL Tests in SQL Developer appeared first on Philipp Salvisberg's Blog...

Veröffentlicht 6 Jul 2019 19:23 von triBLOG

Gespeichert unter: Oracle, PL/SQL, SQL Developer, utPLSQL
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

1 2 3 Weiter >

CC BY-NC-ND - Michael Greth

Mit Community Server (Commercial Edition), von Telligent Systems

3DZL:andrewbelon.com

Datenschutzerklärung

Nach Markierungen suchen

Blogs

Sponsored by

Syndication

Recent Posts

Tags

Archives

How to Save 7 Keystrokes with dbms_xplan

Running utPLSQL Tests in SQL Developer

Using DBMS_DEBUG in SQL Developer

MemOptimized RowStore in Oracle Database 19c

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

Dynamic Pivot with Polymorphic Table Function?

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

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

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

Polymorphic Table Functions (PTF) – Tinkering with Rowsets

Polymorphic Table Functions (PTF) , Part 1 – Basics

View-API for JOOQ Application

The Pink Database Paradigm (PinkDB)

Is Your Application SmartDB?

MemOptimized RowStore in Oracle Database 18c