SharePointCommunity
Die deutschsprachige Community für SharePoint, Microsoft 365, Teams, Yammer und mit Azure
Anmelden
|
Beitreten
|
Hilfe
Home
Angebote
Blogs
Foren
Podcast
Youtube
Social
Wikis
ToolBox
Partner
UserGroups
Termine
Impressum
SharePointPodcast
M.Greth
@IntranetBabett
TechNet
Mirror
UserGroups
SharePoint Mirror
»
Alle Tags
»
PL/SQL
(
RSS
)
Nach Markierungen suchen
Blogs
SharePoint Mirror
Home
Sponsored by
Partner
Syndication
RSS
Atom
Kommentar-RSS
E-Mail-Aktualisierungen empfangen
Abonnieren
Recent Posts
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
Tags
Allgemein
Azure
Cloud
deutsch
Developer
Development
english
HowTo
Microsoft
MVP
News
Newsticker
next Generation Sync Client
Office 2010
Office 2013
Office 365
Office365
OneDrive
OneDrive for Business
SharePoint
SharePoint 2010
Sharepoint 2013
SharePoint Online
Ticker
Tipps
View more
Archives
Februar 2021 (11)
Januar 2021 (8)
Dezember 2020 (16)
November 2020 (20)
Oktober 2020 (24)
September 2020 (26)
August 2020 (20)
Juli 2020 (39)
Juni 2020 (26)
Mai 2020 (32)
April 2020 (26)
März 2020 (42)
Februar 2020 (28)
Januar 2020 (34)
Dezember 2019 (38)
November 2019 (28)
Oktober 2019 (32)
September 2019 (40)
August 2019 (31)
Juli 2019 (45)
Juni 2019 (54)
Mai 2019 (60)
April 2019 (40)
März 2019 (65)
Februar 2019 (56)
Januar 2019 (68)
Dezember 2018 (43)
November 2018 (47)
Oktober 2018 (54)
September 2018 (41)
August 2018 (45)
Juli 2018 (60)
Juni 2018 (76)
Mai 2018 (84)
April 2018 (88)
März 2018 (83)
Februar 2018 (91)
Januar 2018 (113)
Dezember 2017 (95)
November 2017 (85)
Oktober 2017 (97)
September 2017 (121)
August 2017 (60)
Juli 2017 (101)
Juni 2017 (92)
Mai 2017 (92)
April 2017 (111)
März 2017 (130)
Februar 2017 (110)
Januar 2017 (101)
Dezember 2016 (113)
November 2016 (107)
Oktober 2016 (129)
September 2016 (108)
August 2016 (84)
Juli 2016 (87)
Juni 2016 (95)
Mai 2016 (139)
April 2016 (104)
März 2016 (106)
Februar 2016 (83)
Januar 2016 (98)
Dezember 2015 (96)
November 2015 (106)
Oktober 2015 (94)
September 2015 (71)
August 2015 (76)
Juli 2015 (93)
Juni 2015 (85)
Mai 2015 (98)
April 2015 (113)
März 2015 (103)
Februar 2015 (107)
Januar 2015 (107)
Dezember 2014 (96)
November 2014 (110)
Oktober 2014 (141)
September 2014 (146)
August 2014 (106)
Juli 2014 (136)
Juni 2014 (133)
Mai 2014 (129)
April 2014 (143)
März 2014 (195)
Februar 2014 (150)
Januar 2014 (143)
Dezember 2013 (144)
November 2013 (130)
Oktober 2013 (173)
September 2013 (140)
August 2013 (120)
Juli 2013 (148)
Juni 2013 (155)
Mai 2013 (148)
April 2013 (164)
März 2013 (155)
Februar 2013 (151)
Januar 2013 (209)
Dezember 2012 (182)
November 2012 (190)
Oktober 2012 (219)
September 2012 (164)
August 2012 (167)
Juli 2012 (203)
Juni 2012 (112)
Mai 2012 (144)
April 2012 (150)
März 2012 (163)
Februar 2012 (164)
Januar 2012 (112)
Dezember 2011 (158)
November 2011 (120)
Oktober 2011 (101)
September 2011 (93)
August 2011 (80)
Juli 2011 (102)
Juni 2011 (139)
Mai 2011 (124)
April 2011 (134)
März 2011 (179)
Februar 2011 (102)
Januar 2011 (86)
Dezember 2010 (85)
November 2010 (54)
Oktober 2010 (108)
September 2010 (108)
August 2010 (57)
Juli 2010 (84)
Juni 2010 (67)
Mai 2010 (68)
April 2010 (65)
März 2010 (55)
Februar 2010 (66)
Januar 2010 (64)
Dezember 2009 (52)
November 2009 (64)
Oktober 2009 (138)
September 2009 (59)
August 2009 (43)
Juli 2009 (35)
Juni 2009 (25)
Mai 2009 (32)
April 2009 (11)
März 2009 (6)
Februar 2009 (1)
Januar 2009 (7)
Dezember 2008 (1)
September 2008 (1)
Juni 2006 (1)
"table function"
18c
accessible_by_clause
Allgemein
Code Analysis
Db2
Debugging
Dependency Analysis
docker
DWH Automation
EnterpriseDB
ETL
FETCH_ROWS
github
HSQL
Jenkins
jOOQ
MariaDB
MySQL
oddgen
Oracle
Oracle 10g
Oracle 11g
Oracle 11gR2
Oracle 12c
Oracle 12cR1
Oracle 12cR2
Oracle 18c
oracle 19c
Oracle Data Integrator
Oracle Warehouse Builder
Partitioning
Performance
phs
PinkDB
Pivot
PL/Scope
PL/SQL Analyzer
PL/SQL Cop
PL/SQL Developer
polymorphic
polymorphic table function
polymorphic table functions
postgresql
PTF
row repliaction
row set
rowset
Security
SmartDB
SonarQube
SQL
SQL Developer
SQL injection
SQL Server
tabellenfunktion
Teradata
transponieren
Trivadis
TVD
TVDCA
TVDCC
UNIVOT
unwrap
utPLSQL
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
3DZL:andrewbelon.com
Datenschutzerklärung