NOTE: Don't forget to prefix the view name with 'lepmeas.' to be able to see it.
V_AP_COL
V_L3_COL
V_ALEPH_COL
V_OPAL_COL
V_DELPHI_COL
Example : The following call returns the collimator names & positions of interest to L3.
select to_char(timestamp,'DD-MON-YY HH24:MI:SS'), hw_name, position
from LEPMEAS.V_L3_COL;
Here you find PRO*C and C code which demonstrate the use :
Example PRO*C Program to access the collimators of interest to L3
Example C Program which calls the above routine
A trigger will update the collimator table in the Measurement Database as soon as a change to the control database occured (change in collimator position).