Karin_Wasinger_8156

DB - Selects zum Auslesen der UC_SYSTEM_SETTINGS

Discussion created by Karin_Wasinger_8156 on Oct 31, 2016
Latest reply on Nov 3, 2016 by Wolfgang_Brueckler_1288

a) ORACLE

-- 01 -- current system settings

select ovw_oh_client, substr(ovw_vvalue,1,60), ovw_value1 from ovw

                where ovw_oh_idnr in (select oh_idnr from oh where oh_client = 0 and oh_name = 'UC_SYSTEM_SETTINGS');

 

b) MSSQL

-- 01 -- current system settings

               select ovw_oh_client, substring(ovw_vvalue,1,60), ovw_value1 from ovw

                where ovw_oh_idnr in (select oh_idnr from oh where oh_name = 'UC_SYSTEM_SETTINGS') order by 1;

Outcomes