100codeexamples

Samuel Nitsche

Sep 12 '19

Concatenate a List of Strings in PL/SQL

#100codeexamples #plsql #oracle

14

5 min read

Samuel Nitsche

Jul 31 '19

Structure Force Powers with PL/SQL Object Types

#100codeexamples #plsql #sql #sqltypes

8

6 min read

Samuel Nitsche

Jul 31 '19

Narrate Star Wars Movies with utPLSQL annotations

#100codeexamples #utplsql

6

4 min read

Samuel Nitsche

Jun 26 '19

More Pitfalls of the MINUS comparison

#100codeexamples #sql #testing #minus

7

3 min read

Samuel Nitsche

Jun 7 '19

Updating a Table with the Values of a Different One

#100codeexamples #oracle #sql #database

5

2 min read

Samuel Nitsche

Jun 6 '19

Pitfalls of the MINUS-comparison

#100codeexamples #sql #testing #database

6

3 min read

Samuel Nitsche

Jun 5 '19

#100CodeExamples – Constants in PL/SQL and SQL

#100codeexamples #plsql #sql #oracle

9

3 min read

Samuel Nitsche

Mar 22 '19

#100CodeExamples – Only one active protocol

#100codeexamples #sql

6

2 min read

Samuel Nitsche

Mar 11 '19

#100CodeExamples – Use the force to replace objects

#100codeexamples #plsql #oracle

4

2 min read

Samuel Nitsche

Jan 15 '19

#100CodeExamples – PL/SQL BOOLEAN to INT

#100codeexamples #plsql #oracle #sql

6

2 min read

Samuel Nitsche

Jan 15 '19

#100CodeExamples – SYSDATE vs. CURRENT_DATE

#100codeexamples #sql #utplsql #oracle

9

2 min read

Samuel Nitsche

Dec 11 '18

#100CodeExamples – Dynamic values in a String: UTL_LMS

#100codeexamples #plsql #oracle

6

2 min read

Samuel Nitsche

Dec 6 '18

#100CodeExamples – Unit-Tests for Primary/Secondary Lookup with Cursor Comparison

#100codeexamples #oracle #utplsql

6

2 min read

Samuel Nitsche

Dec 4 '18

#100CodeExamples – A challenge to learn and teach: Primary/Secondary Lookup

#100codeexamples #sql

8

3 min read

Samuel Nitsche

Oct 10 '19

OGB Appreciation Day: Explore a utPLSQL test scenario with “force-manual-rollback”

#100codeexamples #plsql #testing #utplsql

5

4 min read

Samuel Nitsche

Aug 2 '19

PL/SQL Object Types: putting the Structure into the Force Powers Table

#100codeexamples #plsql #sql #sqltypes

5

5 min read

Samuel Nitsche

Jun 5 '19

#100CodeExamples – Test updatable views with utPLSQL Cursors

#100codeexamples #plsql #utplsql #oracle

5

3 min read

Samuel Nitsche

Jun 11 '19

Testing the Deathstar security with utPLSQL contexts

#100codeexamples #utplsql #plsql #sql

7

4 min read

Samuel Nitsche

Feb 21 '19

#100CodeExamples – utPLSQL Cursor Comparison with user-defined Types

#100codeexamples #plsql #utplsql #oracle

8

3 min read

Samuel Nitsche

Jan 23 '19

#100CodeExamples – PL/SQL Objects: Basics of force-sensitive beings

#100codeexamples #plsql #oracle

5

2 min read

Samuel Nitsche

Dec 17 '18

#100CodeExamples – utPLSQL’s Suite Hierarchy in action

#100codeexamples #plsql #utplsql #testing

6

2 min read

DEV Community 👩‍💻👨‍💻

DEV Community 👩‍💻👨‍💻 is a community of 966,904 amazing developers

# 100codeexamples

Concatenate a List of Strings in PL/SQL

Structure Force Powers with PL/SQL Object Types

Narrate Star Wars Movies with utPLSQL annotations

More Pitfalls of the MINUS comparison

Updating a Table with the Values of a Different One

Pitfalls of the MINUS-comparison

#100CodeExamples – Constants in PL/SQL and SQL

#100CodeExamples – Only one active protocol

#100CodeExamples – Use the force to replace objects

#100CodeExamples – PL/SQL BOOLEAN to INT

#100CodeExamples – SYSDATE vs. CURRENT_DATE

#100CodeExamples – Dynamic values in a String: UTL_LMS

#100CodeExamples – Unit-Tests for Primary/Secondary Lookup with Cursor Comparison

#100CodeExamples – A challenge to learn and teach: Primary/Secondary Lookup

OGB Appreciation Day: Explore a utPLSQL test scenario with “force-manual-rollback”

PL/SQL Object Types: putting the Structure into the Force Powers Table

#100CodeExamples – Test updatable views with utPLSQL Cursors

Testing the Deathstar security with utPLSQL contexts

#100CodeExamples – utPLSQL Cursor Comparison with user-defined Types

#100CodeExamples – PL/SQL Objects: Basics of force-sensitive beings

#100CodeExamples – utPLSQL’s Suite Hierarchy in action