OnlineDB/EcalCondDB/sql/create_beam_source.sql - master - githubmirror/cmssw

OnlineDB/EcalCondDB/sql/create_beam_source.sql

10 строк358 B

Giulio Eulisse

Snapshot of CMSSW_6_2_0_pre8.

26 июн 2013, 18:12

26 июн 2013, 18:12214ab73

DROP DATABASE LINK lhclogdb;

CREATE DATABASE LINK lhclogdb CONNECT TO measdb_pub IDENTIFIED BY meas2005 USING 'sunlhclog01.cern.ch:1521/LHCLOGDB';

SELECT count(*) FROM v_client_spsea_vars_last_vals@lhclogdb;

CREATE VIEW beam_source AS
SELECT * FROM v_client_spsea_vars_last_vals@lhclogdb WHERE beamline IN ('H4', 'H2');

SELECT count(*) FROM beam_source;