Variable type Substitution in Test Window

[osvald]

Please explain or give an example how to work with variable type "Substitution" in Test Window ? (Is this new type?)

 

[Marco Kalter]

This is not a new type. You can use the substitution variable type in cases where bind variables are not allowed. For example to specify a table name:

begin
  select count(*) into :v_count from :v_table;
end;

In this case "v_table" needs to be declared as a substitution variable.

 

[osvald]

Ok, it's clear.
Thank you !