PL/SQL Archives - Page 2 of 2

Structure Force Powers with PL/SQL Object Types

Modern SQL and especially PL/SQL is turing complete and can be used to solve every problem, but Oracle SQL Types can help greatly to do it in a much more readable way.

By Sam, 5 years ago

Testing the Deathstar security with utPLSQL contexts

The context-feature of #utPLSQL can greatly help to organize your tests and reduce the setup/teardown time of tests.
Learn how to use them to test the Deathstar security system.
#100CodeExamples

By Sam, 6 years ago

#100CodeExamples – Test updatable views with utPLSQL Cursors

If it comes to testing updatable views, the use of nested tables from ROWTYPE records in combination with utPLSQL’s cursor comparison is invaluable.

By Sam, 6 years ago

#100CodeExamples – Constants in PL/SQL and SQL

Constants help us lazy devs in many ways, reduce the likelyness of unnoticed typos and prevent a given value from changing.
While PL/SQL supports them, it’s a bit tricky to get them into SQL.

By Sam, 6 years ago

#100CodeExamples – Use the force to replace objects

Objects in oracle can be used to create nested table collections, which are accessible from SQL.
However, to change these objects once referenced by a table type can be very annoying unless you use the force.

By Sam, 6 years ago

#100CodeExamples

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

#100CodeExamples: Cursor-comparison is one of the most powerful features of utPLSQL.
To model our expectation, we can not only use SELECT FROM DUAL but also the much more powerful user-defined types and Nested Table-collections.

By Sam, 6 years ago

#100CodeExamples

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

#100CodeExamples – Implement some different force-sensitive beings with PL/SQL objects.
This is the first of several examples showing the object-oriented capabilities of PL/SQL.

By Sam, 6 years ago