Learning is not a spectator sport
Connor McDonald on SQL and the Oracle Database
Tag: sys_context
Grab all the DDL
I posted a video a couple of days ago showing a trigger mechanism to customize the capture of DDL that is issued on your database. The aim here is to be more generous with letting developers execute DDL on their Development databases, whilst still…
Taking a peek at SYS_CONTEXT
There was Twitter discussion about using context variables, accessed via SYS_CONTEXT within queries. It’s an easy means of passing parameters into a view. The question that got asked was – does a sys_context variable act exactly like a bind variable. Let’s take a look…
