Learning is not a spectator sport
Connor McDonald on SQL and the Oracle Database
Tag: parameters
PL/SQL – Don’t mix and match scope
Here’s a simple little PL/SQL block where we call an inner procedure PARAMETER_TESTER from its parent block. Pay particular attention to the parameter we pass to the procedure, and it’s value throughout the execution of that procedure. SQL> set serverout on SQL> declare 2…
Idle banter
When your car gets a flat tyre, it’s always handy to have a spare. We do the same with the database SQL> select 2 x.ksppinm name 3 from 4 sys.x$ksppi x, 5 sys.x$ksppcv2 y 6 where 7 x.inst_id = userenv(‘Instance’) and 8 y.inst_id =…
