Skip to content
Navigation menu
Search
Powered by
Search
Algolia
Search
Log in
Create account
DEV Community
Close
#
100codeexamples
Follow
Hide
Posts
Left menu
đź‘‹
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
Right menu
Deeply Nested XML and JSON with SQL
Samuel Nitsche
Samuel Nitsche
Samuel Nitsche
Follow
Feb 24 '23
Deeply Nested XML and JSON with SQL
#
100codeexamples
#
sql
#
oracle
Comments
Add Comment
3 min read
Concatenate a List of Strings in PL/SQL
Samuel Nitsche
Samuel Nitsche
Samuel Nitsche
Follow
Sep 12 '19
Concatenate a List of Strings in PL/SQL
#
100codeexamples
#
plsql
#
oracle
13
 reactions
Comments
Add Comment
5 min read
PL/SQL Object Types: putting the Structure into the Force Powers Table
Samuel Nitsche
Samuel Nitsche
Samuel Nitsche
Follow
Aug 2 '19
PL/SQL Object Types: putting the Structure into the Force Powers Table
#
100codeexamples
#
plsql
#
sql
#
sqltypes
6
 reactions
Comments
Add Comment
5 min read
Structure Force Powers with PL/SQL Object Types
Samuel Nitsche
Samuel Nitsche
Samuel Nitsche
Follow
Jul 31 '19
Structure Force Powers with PL/SQL Object Types
#
100codeexamples
#
plsql
#
sql
#
sqltypes
7
 reactions
Comments
Add Comment
6 min read
Narrate Star Wars Movies with utPLSQL annotations
Samuel Nitsche
Samuel Nitsche
Samuel Nitsche
Follow
Jul 31 '19
Narrate Star Wars Movies with utPLSQL annotations
#
100codeexamples
#
utplsql
6
 reactions
Comments
Add Comment
4 min read
More Pitfalls of the MINUS comparison
Samuel Nitsche
Samuel Nitsche
Samuel Nitsche
Follow
Jun 26 '19
More Pitfalls of the MINUS comparison
#
100codeexamples
#
sql
#
testing
#
minus
7
 reactions
Comments
Add Comment
3 min read
Testing the Deathstar security with utPLSQL contexts
Samuel Nitsche
Samuel Nitsche
Samuel Nitsche
Follow
Jun 11 '19
Testing the Deathstar security with utPLSQL contexts
#
100codeexamples
#
utplsql
#
plsql
#
sql
7
 reactions
Comments
Add Comment
4 min read
Updating a Table with the Values of a Different One
Samuel Nitsche
Samuel Nitsche
Samuel Nitsche
Follow
Jun 7 '19
Updating a Table with the Values of a Different One
#
100codeexamples
#
oracle
#
sql
#
database
5
 reactions
Comments
1
 comment
2 min read
Pitfalls of the MINUS-comparison
Samuel Nitsche
Samuel Nitsche
Samuel Nitsche
Follow
Jun 6 '19
Pitfalls of the MINUS-comparison
#
100codeexamples
#
sql
#
testing
#
database
6
 reactions
Comments
Add Comment
3 min read
#100CodeExamples – Test updatable views with utPLSQL Cursors
Samuel Nitsche
Samuel Nitsche
Samuel Nitsche
Follow
Jun 5 '19
#100CodeExamples – Test updatable views with utPLSQL Cursors
#
100codeexamples
#
plsql
#
utplsql
#
oracle
5
 reactions
Comments
Add Comment
3 min read
#100CodeExamples – Constants in PL/SQL and SQL
Samuel Nitsche
Samuel Nitsche
Samuel Nitsche
Follow
Jun 5 '19
#100CodeExamples – Constants in PL/SQL and SQL
#
100codeexamples
#
plsql
#
sql
#
oracle
8
 reactions
Comments
Add Comment
3 min read
#100CodeExamples – Only one active protocol
Samuel Nitsche
Samuel Nitsche
Samuel Nitsche
Follow
Mar 22 '19
#100CodeExamples – Only one active protocol
#
100codeexamples
#
sql
6
 reactions
Comments
Add Comment
2 min read
#100CodeExamples – Use the force to replace objects
Samuel Nitsche
Samuel Nitsche
Samuel Nitsche
Follow
Mar 11 '19
#100CodeExamples – Use the force to replace objects
#
100codeexamples
#
plsql
#
oracle
4
 reactions
Comments
Add Comment
2 min read
#100CodeExamples – utPLSQL Cursor Comparison with user-defined Types
Samuel Nitsche
Samuel Nitsche
Samuel Nitsche
Follow
Feb 21 '19
#100CodeExamples – utPLSQL Cursor Comparison with user-defined Types
#
100codeexamples
#
plsql
#
utplsql
#
oracle
8
 reactions
Comments
Add Comment
3 min read
#100CodeExamples – PL/SQL Objects: Basics of force-sensitive beings
Samuel Nitsche
Samuel Nitsche
Samuel Nitsche
Follow
Jan 23 '19
#100CodeExamples – PL/SQL Objects: Basics of force-sensitive beings
#
100codeexamples
#
plsql
#
oracle
5
 reactions
Comments
Add Comment
2 min read
#100CodeExamples – PL/SQL BOOLEAN to INT
Samuel Nitsche
Samuel Nitsche
Samuel Nitsche
Follow
Jan 15 '19
#100CodeExamples – PL/SQL BOOLEAN to INT
#
100codeexamples
#
plsql
#
oracle
#
sql
5
 reactions
Comments
Add Comment
2 min read
#100CodeExamples – SYSDATE vs. CURRENT_DATE
Samuel Nitsche
Samuel Nitsche
Samuel Nitsche
Follow
Jan 15 '19
#100CodeExamples – SYSDATE vs. CURRENT_DATE
#
100codeexamples
#
sql
#
utplsql
#
oracle
9
 reactions
Comments
Add Comment
2 min read
#100CodeExamples – utPLSQL’s Suite Hierarchy in action
Samuel Nitsche
Samuel Nitsche
Samuel Nitsche
Follow
Dec 17 '18
#100CodeExamples – utPLSQL’s Suite Hierarchy in action
#
100codeexamples
#
plsql
#
utplsql
#
testing
6
 reactions
Comments
Add Comment
2 min read
#100CodeExamples – Dynamic values in a String: UTL_LMS
Samuel Nitsche
Samuel Nitsche
Samuel Nitsche
Follow
Dec 11 '18
#100CodeExamples – Dynamic values in a String: UTL_LMS
#
100codeexamples
#
plsql
#
oracle
6
 reactions
Comments
Add Comment
2 min read
#100CodeExamples – Unit-Tests for Primary/Secondary Lookup with Cursor Comparison
Samuel Nitsche
Samuel Nitsche
Samuel Nitsche
Follow
Dec 6 '18
#100CodeExamples – Unit-Tests for Primary/Secondary Lookup with Cursor Comparison
#
100codeexamples
#
oracle
#
utplsql
7
 reactions
Comments
Add Comment
2 min read
#100CodeExamples – A challenge to learn and teach: Primary/Secondary Lookup
Samuel Nitsche
Samuel Nitsche
Samuel Nitsche
Follow
Dec 4 '18
#100CodeExamples – A challenge to learn and teach: Primary/Secondary Lookup
#
100codeexamples
#
sql
8
 reactions
Comments
Add Comment
3 min read
loading...
We're a place where coders share, stay up-to-date and grow their careers.
Log in
Create account