Schema browser
Save
Open
Query SQL
db format owner db rownum html pre multi export
select fn_ord_colore( peri_v), peri_v, id_misura from bs_risultati where data ='20020228' and id_pdc ='CO' and id_misura in (select id_misura from bs_misure where bs_obiettivi = 10)

FN_ORD_COLOREPERI_VID_MISURA
0.56528057
0.56528058
131

elapsed=0.14166104793549 sec

select sum(fn_ord_colore (peri_v) * natumisu *fn_segno(m.direzione)) / (sum(natumisu)*1.0) as peri_v, sum(fn_ord_colore (peri_v) * natumisu *fn_segno(m.direzione)) as s1, (sum(natumisu)*1.0) as s2 from bs_risultati r, bs_misure m where r.id_misura = m.id_misura and data ='20020228' and id_pdc ='CO' and bs_obiettivi = 10 group by data, id_pdc, bs_obiettivi

PERI_VS1S2
0.37538

elapsed=0.028438925743103 sec

select id_misura, descr, natumisu from bs_misure where bs_obiettivi = 10

ID_MISURADESCRNATUMISU
57OpportunitÓ alla data - lordo3
131Clienti vs. Prospect2
112Incidenza Clienti Non Audit (non disp)1
58OpportunitÓ alla data - netto3
145Incidenza Compliance1

elapsed=0.0038861036300659 sec

select * from bs_bs

GRANULARITA_ANDGRANULARITA_ORGROUP_SEPARATORDECIMAL_SEPARATORDECIMAL_DIGITSLINGUA_LOCALLINGUA_INTERNATIONAL
FFFFFF000000.,212

elapsed=0.0039550065994263 sec

select * from vw_lingue order by 1

CODDESCR_INGLDESCRCHARSET
1ItalianItaliano
2EnglishInglese
3CroatianCroato
4JapaneseGiapponeseShift_JIS

elapsed=0.01276695728302 sec


ALT-Q focus on query ALT-ENTER submits ALT-E explains