utPLSQL tip!
The coverage regex matching options are not anchored.
-include-object-expr='ORD' also matches RECORD_PKG and BORDER.
Use anchors to describe what you mean:
'^ORD' - match all objects starting with `ORD`
'ORD$' - match all objects ending with `ORD`
#utPLSQL #PLSQL
The coverage regex matching options are not anchored.
-include-object-expr='ORD' also matches RECORD_PKG and BORDER.
Use anchors to describe what you mean:
'^ORD' - match all objects starting with `ORD`
'ORD$' - match all objects ending with `ORD`
#utPLSQL #PLSQL
utPLSQL-cli 3.2.2 is out
Define your code coverage scope with regular expressions: include or exclude whole schemas and objects by pattern. New objects that match your naming rules are covered automatically.
www.utplsql.org/announcement...
Define your code coverage scope with regular expressions: include or exclude whole schemas and objects by pattern. New objects that match your naming rules are covered automatically.
www.utplsql.org/announcement...
utPLSQL-cli v3.2.2 released - utPLSQL
When project files are mapped to database objects (-source_path / -test_path), coverage is already limited to those files. The new options are for code that cannot be mapped…
www.utplsql.org
October 22, 2026 at 1:47 PM
Thanks to @lwasylow.bsky.social for implementing this feature in utPLSQL core some time ago.
October 20, 2026 at 7:08 AM
Thanks to @lwasylow.bsky.social for implementing this feature in utPLSQL core some time ago.
Coverage scope as a regex. New in utPLSQL-cli 3.2.2:
@utplsql.org
-include-schema-expr='^APP_'
-exclude-object-expr='(_TMP|_GEN)$'
New packages follow your naming conventions automatically, no list to update. Recipes and traps:
oraclethoughts.com/blog/2026/10...
#utPLSQL #PLSQL
@utplsql.org
-include-schema-expr='^APP_'
-exclude-object-expr='(_TMP|_GEN)$'
New packages follow your naming conventions automatically, no list to update. Recipes and traps:
oraclethoughts.com/blog/2026/10...
#utPLSQL #PLSQL
Defining code coverage scope with regular expressions in utPLSQL-cli - oraclethoughts
Oracle database, PL/SQL development, utPLSQL, testing and contemplative notes
oraclethoughts.com
October 20, 2026 at 7:09 AM
Coverage scope as a regex. New in utPLSQL-cli 3.2.2:
@utplsql.org
-include-schema-expr='^APP_'
-exclude-object-expr='(_TMP|_GEN)$'
New packages follow your naming conventions automatically, no list to update. Recipes and traps:
oraclethoughts.com/blog/2026/10...
#utPLSQL #PLSQL
@utplsql.org
-include-schema-expr='^APP_'
-exclude-object-expr='(_TMP|_GEN)$'
New packages follow your naming conventions automatically, no list to update. Recipes and traps:
oraclethoughts.com/blog/2026/10...
#utPLSQL #PLSQL
utPLSQL-cli 3.2.2 is out
Define your code coverage scope with regular expressions: include or exclude whole schemas and objects by pattern. New objects that match your naming rules are covered automatically.
www.utplsql.org/announcement...
Define your code coverage scope with regular expressions: include or exclude whole schemas and objects by pattern. New objects that match your naming rules are covered automatically.
www.utplsql.org/announcement...
utPLSQL-cli v3.2.2 released - utPLSQL
When project files are mapped to database objects (-source_path / -test_path), coverage is already limited to those files. The new options are for code that cannot be mapped…
www.utplsql.org
October 19, 2026 at 8:30 PM
utPLSQL-cli 3.2.2 is out
Define your code coverage scope with regular expressions: include or exclude whole schemas and objects by pattern. New objects that match your naming rules are covered automatically.
www.utplsql.org/announcement...
Define your code coverage scope with regular expressions: include or exclude whole schemas and objects by pattern. New objects that match your naming rules are covered automatically.
www.utplsql.org/announcement...
utPLSQL is now stewarded by utPLSQL Development Labs Ltd.
utPLSQL remains free and open source under the Apache License 2.0. The company holds the name and brand, and manages sponsorships and funded development.
www.utplsql.org/announcement...
#utPLSQL #PLSQL #OpenSource
utPLSQL remains free and open source under the Apache License 2.0. The company holds the name and brand, and manages sponsorships and funded development.
www.utplsql.org/announcement...
#utPLSQL #PLSQL #OpenSource
September 28, 2026 at 1:28 PM
utPLSQL is now stewarded by utPLSQL Development Labs Ltd.
utPLSQL remains free and open source under the Apache License 2.0. The company holds the name and brand, and manages sponsorships and funded development.
www.utplsql.org/announcement...
#utPLSQL #PLSQL #OpenSource
utPLSQL remains free and open source under the Apache License 2.0. The company holds the name and brand, and manages sponsorships and funded development.
www.utplsql.org/announcement...
#utPLSQL #PLSQL #OpenSource
@utplsql.org now has a legal home: utPLSQL Development Labs Ltd.
After years of maintaining it in my spare time, I decided it needs a sustainable structure. It stays free and open source (Apache 2.0).
Why, and what's next:
oraclethoughts.com/blog/2026/09...
#utPLSQL #PLSQL #OracleDatabase
After years of maintaining it in my spare time, I decided it needs a sustainable structure. It stays free and open source (Apache 2.0).
Why, and what's next:
oraclethoughts.com/blog/2026/09...
#utPLSQL #PLSQL #OracleDatabase
Incorporation of utPLSQL - oraclethoughts
Oracle database, PL/SQL development, utPLSQL, testing and contemplative notes
oraclethoughts.com
September 28, 2026 at 1:27 PM
@utplsql.org now has a legal home: utPLSQL Development Labs Ltd.
After years of maintaining it in my spare time, I decided it needs a sustainable structure. It stays free and open source (Apache 2.0).
Why, and what's next:
oraclethoughts.com/blog/2026/09...
#utPLSQL #PLSQL #OracleDatabase
After years of maintaining it in my spare time, I decided it needs a sustainable structure. It stays free and open source (Apache 2.0).
Why, and what's next:
oraclethoughts.com/blog/2026/09...
#utPLSQL #PLSQL #OracleDatabase
Busy weekend for utPLSQL.
utPLSQL-cli and maven-plugin have new releases.
utPLSQL-cli and maven-plugin have new releases.
September 27, 2026 at 8:20 PM
Busy weekend for utPLSQL.
utPLSQL-cli and maven-plugin have new releases.
utPLSQL-cli and maven-plugin have new releases.
utPLSQL-cli 3.2.1 and utPLSQL-maven-plugin 3.2.1 are out.
Both add Oracle Wallet support for connections. The cli also has fixes to keep credentials out of logs.
cli: tinyurl.com/94c56zuv
Maven plugin: on Maven Central, just update your pom.
#utPLSQL #PLSQL #OracleDB
@utplsql.org
Both add Oracle Wallet support for connections. The cli also has fixes to keep credentials out of logs.
cli: tinyurl.com/94c56zuv
Maven plugin: on Maven Central, just update your pom.
#utPLSQL #PLSQL #OracleDB
@utplsql.org
Release utPLSQL-cli v3.2.1 · utPLSQL/utPLSQL-cli
What's Changed
Allow /@TNS connections using Oracle Wallet (Secure External Password Store) by @jgebal in #230
Update of java-api-version dependency by @jgebal in #231
Don't reveal credentials in ...
tinyurl.com
September 27, 2026 at 8:16 PM
utPLSQL-cli 3.2.1 and utPLSQL-maven-plugin 3.2.1 are out.
Both add Oracle Wallet support for connections. The cli also has fixes to keep credentials out of logs.
cli: tinyurl.com/94c56zuv
Maven plugin: on Maven Central, just update your pom.
#utPLSQL #PLSQL #OracleDB
@utplsql.org
Both add Oracle Wallet support for connections. The cli also has fixes to keep credentials out of logs.
cli: tinyurl.com/94c56zuv
Maven plugin: on Maven Central, just update your pom.
#utPLSQL #PLSQL #OracleDB
@utplsql.org
utPLSQL is designed to allow for various reporting formats.
Check out this post to get familiar with what is available out of the box.
Check out this post to get familiar with what is available out of the box.
When designing utPLSQL we've focused on providing multiple test output reports.
In this post I go briefly through various reporting formats of @utplsql.bsky.social
tinyurl.com/yx5sampu
In this post I go briefly through various reporting formats of @utplsql.bsky.social
tinyurl.com/yx5sampu
utPLSQL starter tips - reporting test results - oraclethoughts
Oracle database, PL/SQL development, utPLSQL, testing and contemplative notes
tinyurl.com
August 21, 2026 at 2:01 PM
utPLSQL is designed to allow for various reporting formats.
Check out this post to get familiar with what is available out of the box.
Check out this post to get familiar with what is available out of the box.
When designing utPLSQL we've focused on providing multiple test output reports.
In this post I go briefly through various reporting formats of @utplsql.bsky.social
tinyurl.com/yx5sampu
In this post I go briefly through various reporting formats of @utplsql.bsky.social
tinyurl.com/yx5sampu
utPLSQL starter tips - reporting test results - oraclethoughts
Oracle database, PL/SQL development, utPLSQL, testing and contemplative notes
tinyurl.com
August 21, 2026 at 1:57 PM
When designing utPLSQL we've focused on providing multiple test output reports.
In this post I go briefly through various reporting formats of @utplsql.bsky.social
tinyurl.com/yx5sampu
In this post I go briefly through various reporting formats of @utplsql.bsky.social
tinyurl.com/yx5sampu
Next week: @oraesque.bsky.social “utPLSQL – The Perfect Testing Tool for Lazy People”.
While waiting, check out my interview with veteran Mariusz Masewicz on avoiding weekend debugging: [https://how2ora-en.blogspot.com/2026/05/interview-with-mariusz-masewicz-man-who.html]
🎙️ Don't miss it!
While waiting, check out my interview with veteran Mariusz Masewicz on avoiding weekend debugging: [https://how2ora-en.blogspot.com/2026/05/interview-with-mariusz-masewicz-man-who.html]
🎙️ Don't miss it!
May 21, 2026 at 9:15 AM
Next week: @oraesque.bsky.social “utPLSQL – The Perfect Testing Tool for Lazy People”.
While waiting, check out my interview with veteran Mariusz Masewicz on avoiding weekend debugging: [https://how2ora-en.blogspot.com/2026/05/interview-with-mariusz-masewicz-man-who.html]
🎙️ Don't miss it!
While waiting, check out my interview with veteran Mariusz Masewicz on avoiding weekend debugging: [https://how2ora-en.blogspot.com/2026/05/interview-with-mariusz-masewicz-man-who.html]
🎙️ Don't miss it!
New PWOW webinar on Unit Testing & code REUSE is coming!
To celebrate, we have a special treat: an exclusive interview with Jacek Gębal, the driving force behind modern utPLSQL (originally founded by Steven Feuerstein). Trade "hope-it-works" for automation! 👇
how2ora-en.blogspot.com/2026/05/who-...
To celebrate, we have a special treat: an exclusive interview with Jacek Gębal, the driving force behind modern utPLSQL (originally founded by Steven Feuerstein). Trade "hope-it-works" for automation! 👇
how2ora-en.blogspot.com/2026/05/who-...
Who Shook Up the World of PL/SQL Testing? A Conversation with Jacek Gębal
A new PWOW webinar is approaching, focusing on a topic often—unfairly—neglected: Unit Testing . 🧪 The key to success isn't just wri...
how2ora-en.blogspot.com
May 12, 2026 at 1:10 PM
New PWOW webinar on Unit Testing & code REUSE is coming!
To celebrate, we have a special treat: an exclusive interview with Jacek Gębal, the driving force behind modern utPLSQL (originally founded by Steven Feuerstein). Trade "hope-it-works" for automation! 👇
how2ora-en.blogspot.com/2026/05/who-...
To celebrate, we have a special treat: an exclusive interview with Jacek Gębal, the driving force behind modern utPLSQL (originally founded by Steven Feuerstein). Trade "hope-it-works" for automation! 👇
how2ora-en.blogspot.com/2026/05/who-...
In drei Tagen ist es soweit!
Neben einem ersten Kennenlernen wollen wir auch über utPLSQL sprechen.
Das Treffen findet online via Microsoft Teams statt.
Alle Interessierten können sich unter apextest.teamworkonline.me anmelden.
Marko
Neben einem ersten Kennenlernen wollen wir auch über utPLSQL sprechen.
Das Treffen findet online via Microsoft Teams statt.
Alle Interessierten können sich unter apextest.teamworkonline.me anmelden.
Marko
LinkedIn
This link will take you to a page that’s not on LinkedIn
lnkd.in
July 21, 2025 at 5:27 AM
In drei Tagen ist es soweit!
Neben einem ersten Kennenlernen wollen wir auch über utPLSQL sprechen.
Das Treffen findet online via Microsoft Teams statt.
Alle Interessierten können sich unter apextest.teamworkonline.me anmelden.
Marko
Neben einem ersten Kennenlernen wollen wir auch über utPLSQL sprechen.
Das Treffen findet online via Microsoft Teams statt.
Alle Interessierten können sich unter apextest.teamworkonline.me anmelden.
Marko
IT-Tage: Datenbankentwicklung in der Gitlab-Pipeline – wieso hat mir das vorher niemand über Liquibase gesagt?
Details:
www.ittage.informatik-aktuell.de/programm/202...
Details:
www.ittage.informatik-aktuell.de/programm/202...
Datenbankentwicklung in der Gitlab-Pipeline – wieso hat mir das vorher niemand über Liquibase gesagt?
Die Erstellung einer Datenbank-Pipeline aus Shell-Skripten und Oracle sqlcl sowie Liquibase, utPLSQL und Gitlab zeigt dieser Vortrag.
www.ittage.informatik-aktuell.de
November 22, 2024 at 10:23 AM
IT-Tage: Datenbankentwicklung in der Gitlab-Pipeline – wieso hat mir das vorher niemand über Liquibase gesagt?
Details:
www.ittage.informatik-aktuell.de/programm/202...
Details:
www.ittage.informatik-aktuell.de/programm/202...
One of the many things I like about #utPLSQL is that all failed assertions of a test are reported. In this case, I want to ensure that the resulting JSON document contains no surrogate keys.
November 25, 2024 at 11:59 AM
One of the many things I like about #utPLSQL is that all failed assertions of a test are reported. In this case, I want to ensure that the resulting JSON document contains no surrogate keys.
@GebalJacek - What happened to the utPLSQL webinar that was on Vimeo? It’s linked from the resources page on http://utplsql.org but comes up as not found. Was such a great video and I wanted my devs to watch it.
Index - utPLSQL
utPLSQL Ultimate Unit Testing Framework for Oracle PL/SQL
utplsql.org
November 22, 2024 at 9:47 AM
@GebalJacek - What happened to the utPLSQL webinar that was on Vimeo? It’s linked from the resources page on http://utplsql.org but comes up as not found. Was such a great video and I wanted my devs to watch it.
#DOAG2017 - #PL/SQL: Therefore, whoever binds forever: automate your tests! (in german) - compare test tools SQL Developer, ruby-plsql-spec and utPLSQL https://www.doag.org/konferenz/konferenzplaner/konferenzplaner_details.php?locS=0&id=535509&vid=544276
404: DOAG e.V.
www.doag.org
November 28, 2024 at 4:53 AM
#DOAG2017 - #PL/SQL: Therefore, whoever binds forever: automate your tests! (in german) - compare test tools SQL Developer, ruby-plsql-spec and utPLSQL https://www.doag.org/konferenz/konferenzplaner/konferenzplaner_details.php?locS=0&id=535509&vid=544276
#DOAG2017 - #PLSQL: Drum test-automatisiere, wer sich ewig bindet! - Vergleich der Test Tools @OracleSQLDev, ruby-plsql-spec and @utPLSQL https://www.doag.org/konferenz/konferenzplaner/konferenzplaner_details.php?locS=0&id=535509&vid=544276
404: DOAG e.V.
www.doag.org
November 28, 2024 at 4:53 AM
#DOAG2017 - #PLSQL: Drum test-automatisiere, wer sich ewig bindet! - Vergleich der Test Tools @OracleSQLDev, ruby-plsql-spec and @utPLSQL https://www.doag.org/konferenz/konferenzplaner/konferenzplaner_details.php?locS=0&id=535509&vid=544276
My final #DOAG2017 presentation - #PLSQL: Therefore, whoever binds forever: automate your tests! (in german) - is available now here: https://www.slideshare.net/tkleiber/plsql-drum-test-automatisiere-wer-sich-sich-ewig-bindet-doag-2017 (additional to the DOAG website) @utPLSQL
Plsql drum test automatisiere, wer sich sich ewig bindet!...
Plsql drum test automatisiere, wer sich sich ewig bindet!...
www.slideshare.net
November 28, 2024 at 4:53 AM
My final #DOAG2017 presentation - #PLSQL: Therefore, whoever binds forever: automate your tests! (in german) - is available now here: https://www.slideshare.net/tkleiber/plsql-drum-test-automatisiere-wer-sich-sich-ewig-bindet-doag-2017 (additional to the DOAG website) @utPLSQL
To be fair, there was another nice #DOAG2017 database CI presentation by @DmncWsr which contains @utPLSQL, and he had enough time to show the CI part on @jenkinsci too, which you can find only in my upload but not in my talk.
November 28, 2024 at 4:53 AM
To be fair, there was another nice #DOAG2017 database CI presentation by @DmncWsr which contains @utPLSQL, and he had enough time to show the CI part on @jenkinsci too, which you can find only in my upload but not in my talk.
If you never heard from @utplsql or @utlplsqlxl then start here: CodeTalk Series: Unit Testing PL SQL Code in the Real World https://youtu.be/1qAZvS5rvyY
November 28, 2024 at 3:20 AM
If you never heard from @utplsql or @utlplsqlxl then start here: CodeTalk Series: Unit Testing PL SQL Code in the Real World https://youtu.be/1qAZvS5rvyY
In the afternoon of #DevCamp18 evangalizing about @plsql testing with @utPLSQL
November 28, 2024 at 3:20 AM
In the afternoon of #DevCamp18 evangalizing about @plsql testing with @utPLSQL
utPLSQL v3 - Ultimate unit testing framework for #Oracle #database https://www.slideshare.net/jgebal/utplsql-v3-ultimate-unit-testing-framework-for-oracle-prohuddle
prohuddle-utPLSQL v3 - Ultimate unit testing framework fo...
prohuddle-utPLSQL v3 - Ultimate unit testing framework fo...
www.slideshare.net
November 28, 2024 at 12:12 AM
utPLSQL v3 - Ultimate unit testing framework for #Oracle #database https://www.slideshare.net/jgebal/utplsql-v3-ultimate-unit-testing-framework-for-oracle-prohuddle
„Unit Testing Oracle PL/SQL“ with @utPLSQL https://vimeo.com/261135676
November 28, 2024 at 12:12 AM
„Unit Testing Oracle PL/SQL“ with @utPLSQL https://vimeo.com/261135676