SharePointCommunity

Die deutschsprachige Community für SharePoint, Office 365 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

Get Ready for Oracle 12.2

The Oracle 12.2 grammar is now supported in the most current versions of PL/SQL Cop, PL/SQL Cop for SQL Developer, PL/SQL Cop for SonarQube and PL/SQL Analyzer. […] ...read more...( read more ) Mehr…

Veröffentlicht 14 Mai 2017 18:26 von triBLOG

Gespeichert unter: Oracle, PL/SQL, PL/SQL Developer, PL/SQL Cop, SonarQube, PL/SQL Analyzer, Oracle 12cR2
plscope-utils – Utilities for PL/Scope in Oracle Database 12.2

PL/Scope was introduced with Oracle Database version 11.1 and covered PL/SQL only. SQL statements such as SELECT, INSERT, UPDATE, DELETE and MERGE were simply ignored. Analysing […] ...read more...( read more ) Mehr…

Veröffentlicht 17 Mrz 2017 21:14 von triBLOG

Gespeichert unter: Oracle, PL/SQL, Dependency Analysis, Oracle 12cR2, PL/Scope
Trivadis PL/SQL & SQL Coding Guidelines Version 3.1

The latest version 3.1 of the Trivadis PL/SQL & SQL Coding Guidelines has 150 pages. More than 90 additional pages compared to version 2.0. Roger Troller did a tremendous job in updating and extending an already… ...read more...( read more Mehr...

Veröffentlicht 28 Jun 2016 19:47 von triBLOG

Gespeichert unter: SQL, Oracle, PL/SQL, PL/SQL Cop
PL/SQL Bulk Unwrap

406 days ago I’ve released PL/SQL Unwrapper for SQL Developer version 0.1.1 and blogged about it. With this extension you can unwrap the content of a SQL Developer window. Time for an update. With the… ...read more...( read more ) Mehr…

Veröffentlicht 26 Jun 2016 22:44 von triBLOG

Gespeichert unter: Oracle, PL/SQL, SQL Developer, unwrap, oddgen
PL/SQL Cop Meets oddgen

Until August 2015 it never occurred to me that one could use non-PL/SQL code within conditional compilation blocks. Back than we discussed various template engine options as foundation for oddgen – the Oracle community’s dictionary-driven...

Veröffentlicht 26 Apr 2016 21:50 von triBLOG

Gespeichert unter: Oracle, PL/SQL, SQL Developer, TVDCC, PL/SQL Cop, oddgen
Monitoring PL/SQL Code Evolution With PL/SQL Cop for SonarQube

Last week I’ve presented the PL/SQL Cop tool suite to a customer in Germany. While preparing the demo I had taken my first deeper look at the PL/SQL Cop SonarQube plugin, written by Peter Rohner, a… ...read more...( read more ) Mehr…

Veröffentlicht 23 Apr 2016 13:48 von triBLOG

Gespeichert unter: Oracle, PL/SQL, Oracle 12c, TVDCC, PL/SQL Cop, SonarQube
Logging Dynamic SQL

Dynamic SQL is a wonderful feature with a lot of flexibility. Unfortunately, it is not trivial to see the executed SQL statements. A simple trick helps to test and debug PL/SQL code with Dynamic SQL. There are many situations in … Continue reading...

Veröffentlicht 25 Jan 2016 22:23 von triBLOG

Gespeichert unter: SQL, Oracle, ETL, PL/SQL, DWH Automation
The End of Oracle Warehouse Builder – How to Migrate Existing OWB Projects

Oracle Warehouse Builder (OWB) is at the end of its lifecycle. The ETL tool will not be supported by Oracle in the future. But many customers have built data warehouses with OWB. What can they do with their existing OWB … Continue reading →...

Veröffentlicht 21 Jul 2015 11:31 von triBLOG

Gespeichert unter: Oracle, ETL, PL/SQL, Oracle Warehouse Builder, Oracle Data Integrator, DWH Automation
Introducing PL/SQL Unwrapper for SQL Developer

I’m using from time to time the free service Unwrap it! or Niels Teusink’s Python script unwrap.py to unwrap PL/SQL code. Recently I’m confronted more with wrapped code since a customer is about to migrate to a… ...read more.....

Veröffentlicht 17 Mai 2015 17:53 von triBLOG

Gespeichert unter: Oracle, PL/SQL, PL/SQL Developer, unwrap
Trivadis PL/SQL & SQL CodeChecker for SQL Developer Released

A half a year ago Trivadis released a command line utility to scan code within a directory tree for guideline violations of the Trivadis PL/SQL & SQL Coding Guidelines Version 2.0. This… ...read more...( read more ) Mehr…

Veröffentlicht 30 Apr 2014 0:24 von triBLOG

Gespeichert unter: SQL, Oracle, PL/SQL, SQL Developer, Code Analysis, TVDCC
TVDCA 0.5.1 Beta Released

A month ago I had a talk about “Extending the Oracle Data Dictionary for Fine-Grained PL/SQL and SQL Analysis” during the ODTUG Kscope13 conference in New Orleans. Oracle data dictionary views as DBA_IDENTIFIERS or DBA_DEPENDENCIES are in...

Veröffentlicht 28 Jul 2013 20:50 von triBLOG

Gespeichert unter: SQL, Oracle, PL/SQL, Oracle 11gR2, Dependency Analysis, Oracle 12cR1
Trivadis PL/SQL & SQL CodeAnalyzer Released

A month ago I had a talk about “Extending the Oracle Data Dictionary for Fine-Grained PL/SQL and SQL Analysis” during the ODTUG Kscope13 conference in New Orleans. Oracle data dictionary views… ...read more...( read more ) Mehr…

Veröffentlicht 28 Jul 2013 20:50 von triBLOG

Gespeichert unter: SQL, Oracle, PL/SQL, Dependency Analysis, Oracle 10g, Oracle 11g, TVDCA, Oracle 12c
Partition Exchange and Interval Partitioning

Last week I got an interesting question from a former colleague: How can interval partitioning in Oracle 11g be combined with partition exchange? With interval partitioning, it is not possible to create a new partition manually. Usually, this is what...

Veröffentlicht 1 Mai 2012 22:05 von triBLOG

Gespeichert unter: Oracle, ETL, PL/SQL, Partitioning

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

Get Ready for Oracle 12.2

plscope-utils – Utilities for PL/Scope in Oracle Database 12.2

Trivadis PL/SQL & SQL Coding Guidelines Version 3.1

PL/SQL Bulk Unwrap

PL/SQL Cop Meets oddgen

Monitoring PL/SQL Code Evolution With PL/SQL Cop for SonarQube

Logging Dynamic SQL

The End of Oracle Warehouse Builder – How to Migrate Existing OWB Projects

Introducing PL/SQL Unwrapper for SQL Developer

Trivadis PL/SQL & SQL CodeChecker for SQL Developer Released

TVDCA 0.5.1 Beta Released

Trivadis PL/SQL & SQL CodeAnalyzer Released

Partition Exchange and Interval Partitioning