←
utPLSQL403 posts
utPLSQL avatar

utPLSQL

@utPLSQL

Ultimate Testing framework for Oracle PL/SQL

◷ Joined May 2014▧ 21 Photos and videos
utPLSQL avatar
utPLSQL@utPLSQL·Oct 22

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. utplsql.org/announcements/in…

utPLSQL avatar
utPLSQL@utPLSQL·Oct 22

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

utPLSQL-cli 3.2.2: define code coverage scope with regular expressions -include-schema-expr='^APP_' -exclude-object-expr='_TMP$' For code that can't be mapped to project files: include/exclude by pattern, no long lists. utplsql.org/announcements/ut… #utplsql #plsql

utPLSQL avatar
utPLSQL@utPLSQL·Oct 19

Rules worth knowing: * case-insensitive Oracle regex (regexp_like) * object expressions match the name without the schema * an include expression makes --coverage-schemes and -include irrelevant * an exclude expression makes the -exclude list irrelevant

utPLSQL avatar
utPLSQL@utPLSQL·Sep 28

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. utplsql.org/announcement... #utplsql #plsql #opensource

@utPLSQL 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… #utplsql #plsql #oracledatabase

utPLSQL avatar
utPLSQL@utPLSQL·Sep 28

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. utplsql.org/announcements/in… #utplsql #plsql #opensource

@utPLSQL 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… #utplsql #plsql #oracledatabase

utPLSQL avatar
utPLSQL@utPLSQL·Aug 21

utPLSQL is designed to allow for various reporting formats. 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 tinyurl.com/yx5sampu

utPLSQL avatar
utPLSQL@utPLSQL·Aug 14

Financial and regulated companies can't rely on unmaintained software. We are bringing @utPLSQL back to active development and soon will open it up for sponsorship via GitHub Sponsors soon. tinyurl.com/55mem5x7

Jacek Gebal avatar
⟳ utPLSQL retweeted
Jacek Gebal@GebalJacek·Jul 28

When testing the PL/SQL code one of essential elements to test is the dataset that is manipulated or returned. @utPLSQL make it the job easy with build-in result set comparison using cursors. Read more in my starter tips part four: oraclethoughts.com/blog/2026…