In Toad I can build & run following SQL statement:
select to_char(VISUMDYN.DATUM_1, 'DD-MM-YYYY HH24:MI:SS') as TijdstipHandtekening, VISUMDYN.ANWENDER_1 as Handtekening
from AAVARS
inner join AAVALUE on AAVALUE.AAVARS = AAVARS.ID
inner join VISUMDYN on VISUMDYN.ID = to_number(AAVALUE.VALUESTRING)
inner join AAVTS on AAVTS.ID = AAVALUE.AAVTS
inner join VSKNOTEN on VSKNOTEN.ID = AAVTS.VSKNOTEN
where upper(AAVARS.NUMMER) = upper(:VARIABLENAME)
and upper(VSKNOTEN.NUMMER) = upper(:PROCEDURESTEP)
and AAVALUE.AAVTS = :PROCEDURESTEPID;
When running TOAD would show you a popup window, allowing you to input values for each parameter. How do we do this in Aqua Datastudio?