My page on things you can do with PL/SQL - and probably some comments about things you shouldn't do with PL/SQL.
| Title | Content | Last update |
| PL/SQL arrays v7 | Turning a PL/SQL array into an SQL statement (in v7) | 22-Jul-1999 |
| What a bind | Binding and Bind variables in dbms_sql | 13-Jul-1999 |
| Dynamic pl/sql | If you really want to, you can do dynamic selects in PL/SQL | 5-July-1999 |
| In lists | One variable interpreted as an IN list (V 8.0) | 12-Jun-1999 |
| User / Owner | Executing dynamic sql in packages as User, not Owner in in v7 | 11-Jun-1999 |
| PL/SQL tables | Turning a PL/SQL table into an SQL statement (v8) | 11-Jun-1999 |
| Concurrency | A mechanism for concurrent execution of lists of tasks | 26-May-1999 |
| Dec to Hex | A decimal to Hexadecimal function in PL/SQL | 18-May-1999 |
| Performance Now | A package to take performance snapshots or dump stats since startup | 18-May-1999 |
| PLSQL arrays | Array based dynamic SQL in PL/SQL (8.0) | 6-May-1999 |
| Flush | An idea on allowing ordinary users selective DBA rights | 30-Apr-1999 |
| dbms_sql | A little wrapper for simple dynamic SQL | 30-Apr-1999 |
| Logs of performance | Using utl_file to log a series of performance snapshots. | 24-Mar-1999 |
| What's going on | A non-invasive PL/SQL tool for performance snapshots | 24-Feb-1999 |
| Free Space | How much space is actually free in a data segment | 21-Jan-1999 |