× 注意:

Oracle in Aqua Datastudio / fysicus

Aqua Datastudio versus Toad
×
fysicus 質問しました 2013-04-05T09:25:06Z

Parameters

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?

 

バージョン情報 プライバシー ポリシー サポート Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017