Did you know you can execute dynamic PL/SQL? In this Feuertip, Steven offers some tips on writing and running dynamic PL/SQL blocks.
Continuing Steven's series on table functions, Chris Saxon of Oracle AskTOM fame drops by to talk about a fantastic, new Oracle Database feature: SQL macros.
Table functions are wonderful but "typical" tools. In this episode Steven explore a special, strange and delightful version of table functions, called pipelined table functions.
Steven explores how to select not from a table or a view but a function. More specifically, from a table function.
The returning into clause is one of the best examples of the tight integration between SQL and PLSQL. Steven Feuerstein explains.
Steven dives into the PL/SQL function sqlerrm in this week's episode of Feuertips
In this episode of Feuertips, Steven talks about one very special and unusual PL/SQL package, called STANDARD.
When invoking procedures and functions, you can specify arguments for parameters in two different ways: positional and named. In this Feuertip, I will explore the benefits of named notation, aka, =>.
#sqlcode returns the current error code. Ah, but that simple functionality can hide so many interesting little facts.
1 866 887-1670