Guest
- Context:
facing a bad behavior when we want to analyze the plan for a trivial update
- SQL in sql window:
Update schema.table t
set t.status = 'A'
where t.table_id = 12345;
- Action:
asking for explain plan (F5 in my case)
- Result in explain plan window, query changed to Var1 stuff:
Update schema.table t
set t.status = 'A'
where :Var1 = 12345;
- workaround:
manual copy / paste from SQL to explain plan window
facing a bad behavior when we want to analyze the plan for a trivial update
- SQL in sql window:
Update schema.table t
set t.status = 'A'
where t.table_id = 12345;
- Action:
asking for explain plan (F5 in my case)
- Result in explain plan window, query changed to Var1 stuff:
Update schema.table t
set t.status = 'A'
where :Var1 = 12345;
- workaround:
manual copy / paste from SQL to explain plan window
