SQL Id | SQL Text |
02djppxs4a73n | update ol$_locks t set t.obj = null |
05fs85a4b0dy2 | select t.plan_item_id, t.plan_year, t.PLAN_CD,
t.month_plan_cd, t.plan_type,
t.voltage_class_cd, t.voltage_class, t.work_site_id, t.work_site,
t.stop_asset_id, t.stop_asset, t.item_State_Cd,
t.stop_power_switch_id, t.stop_power_switch,
t.org_no, t.org_name, t.dept_no, t.dept_name, t.item_state,
to_char(t.stop_begin_date, 'yyyy-mm-dd hh24:mi:ss') strStopBeginDate, to_char(t.stop_end_date, 'yyyy-mm-dd hh24:mi:ss') strStopEndDate
from t_plan_week_plan_items t
where 1=1 and t.item_state in ('ÒÑ·¢²¼', 'ÒÑÍê³É') and t.org_no like GETORGNO(:1) and t.plan_type_cd =:2 and t.plan_year = :3 and t.plan_cd in (select a.week_plan_id from V_TICKET_QUERY a, V_POWERCUT_QUERY b where a.week_plan_id=b.WEEK_PLAN_CD ) |
0b243yjuy3dvq | select x.attr_uri, x.attr_name, x.attr_disp_name, x.attr_data_type, x.attr_index, x.attr_pos, x.attr_doc, x.cls_uri, x.cls_derive, y.cat_id, y.cat_disp_name, z.con_id, z.can_be_null, z.min_str_len, z.max_str_len, z.min_num_val, z.max_num_val, z.num_precision, z.min_date_val, z.max_date_val, z.attr_cls, e.edt_package, e.edt_class, e.edt_data from ol$_attr_defs x left join ol$_attr_categories y on x.cat_id = y.cat_id left join ol$_attr_constraints z on ol$_core.GETATTRDERIVE(x.attr_uri) = z.attr_uri left join ol$_attr_editors e on ol$_core.getattrprime(x.attr_uri) = e.attr_uri where x.cls_uri = :1 order by x.attr_index |
0cxypy0hx9g11 | select /*+ index(o PK_OL$_OBJECTS) */ * from v$_FamilyLine o where obj_id=:1 |
0jat7ccc9fvct |
Select Pc.Obj_Id,
Pc.Cls_Uri,
Pc.Voltagelevel,
Pc.Pathname,
Ass.Obj_Id Assetid,
Ass.Name Assetname,
Ass.Cls_Uri Asseturi,
Getnamepathbyidpath(Pc.Pathname || Ass.Pathname) Assetnamepath,
c.Cls_Uri Clsuri,
c.Cls_Disp_Name,
Ass.Assetsstatus,
Ass.Manufacturer,
Ass.Sbxh,
Ass.Inservicedate,
Ass.Code
From V$_St_Powersystemresource Pp,
V$_St_Powersystemresource Pc,
Ol$_Associations a,
V$_St_Asset Ass,
Ol$_Classes c
Where Pc.Pathname Like Pp.Pathname || '%'
And Ass.Pathname Like '\' || a.b || '%'
And Pp.Obj_Id =:1
And Pc.Obj_Id = a.a
And Ass.Cls_Uri = c.Cls_Uri
And a.Ast_Uri = 'OLASSOCIATIONTYPE://ST_PowerSystemResource_ST_Asset?A="OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource"&B="OLCLASS://Entity/ST_IdentifiedObject/ST_Asset"' and Pc.orgId=:2 and Ass.orgId=Pc.orgId
and ass.Assetsstatus in( 'S', 'W') and ass.CLS_URI in( 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/ST_AssetContainer/ST_Structure/ST_Pole', 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/ST_ElectricalAsset/ST_LinearConductorAsset/ST_OHConductorAsset', 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/ST_ElectricalAsset/ST_EarthWire/OHEarthWireAsset', 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/ST_ElectricalAsset/ST_LinearConductorAsset/ST_CableAsset', 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/ST_ElectricalAsset/ST_Terminal', 'OLCLASS://Entity/ST_Identifie
dObject/ST_Asset/ST_ElectricalAsset/IntermediateConnectortAsset') |
1f5c885f3vvfx | select /*+ index(v$_ST_Asset IDX_OL$_OBJECTS_CLS_PATHNAME) */ v$_ST_Asset.* from v$_ST_Asset where orgId = :1 and ( (ASSETSSTATUS = :2 OR ASSETSSTATUS = :3) and pathName like :4 ) order by pathName |
1gcnmuw9xtb3k | SELECT CLS_URI FROM OL$_CLASSES WHERE CLS_ID = SUBSTR(:B1 , 1, 32) |
1zqktnh3k2w9h |
SELECT * FROM ( select name "Éú²ú±äѹÆ÷Ãû³Æ",
(select org_name
from sgpm.o_org
where org_no = orgid
And Rownum = 1) "¹©µçµ¥Î»",
(select (select (select name
from olive.v$_st_feeder
where obj_id = substr(o.s_04, 197, 64)
And Rownum = 1)
from olive.ol$_objects o
where obj_id = x.a
And Rownum = 1)
from olive.ol$_associations x
where b = substr(pathname, 2, 64)
And Rownum = 1) "ËùÊôÖ÷Ïß",
(select (select olive.getpathnamebypathid(o.s_04)
from olive.ol$_objects o
where obj_id = x.a
And Rownum = 1)
from olive.ol$_associations x
where b = substr(pathname, 2, 64)
And Rownum = 1) "Éú²ú±äѹÆ÷λÖÃ",
(select (select o.INSERVICEDATE
from olive.v$_st_powersystemresource o
where obj_id = x.a
And Rownum = 1)
from olive.ol$_associations x
where b = substr(pathname, 2, 64)
And Rownum = 1) "ͶÔËÈÕÆÚ",
(select (select (select (select org_name from sgpm.o_org where org_no=p_dept_no) from sgpm.o_dept where dept_no=o.o_15)
from olive.ol$_objects o
where obj_id = x.a
And Rownum = 1)
from olive.ol$_associations x
where b = substr(pathname, 2, 64)
And Rownum = 1) "ά»¤°à×é",
'10kV' "µçѹµÈ¼¶",
ratedCapacity "¶î¶¨ÈÝÁ¿(kVA)",
obj_id "Éú²úID",
(select name
from sgpm.p_code
where value = AssetsStatus
and code_type = 'AssetsState'
And Rownum = 1) "״̬",
CCBH "³ö³§±àºÅ",
(select name
from sgpm.p_code
where value = SBXH
and code_type = 'DisTransAssetXH'
And Rownum = 1) "É豸ÐͺÅ",
(Select Name
From Sgpm.p_Code p
Where Value = (Select Usetype
From Olive.V$_St_Distransformer
Where Obj_Id = (Select a
From Olive.Ol$_Associations
Where b = t.Obj_Id
and rownum = 1))
And p.Code_Type = 'UseType'
and rownum = 1) "ËùÓÃÐÔÖÊ",
(select name
from sgpm.p_code
where code_type = 'BDSB_ZCSSDW'
and value = t.ASSETNATURE) "×ʲúÐÔÖÊ",
decode((select (select ( (select 'Ïä±ä' from v$_ST_BoxStation where obj_id=substr(o.s_04, -129, 64))
)
from olive.ol$_objects o
where obj_id = x.a
A
nd Rownum = 1)
from olive.ol$_associations x
where b = substr(pathname, 2, 64)
And Rownum = 1), 'Ïä±ä', 'ÊÇ', '·ñ') "ÊÇ·ñÏä±ä",
(select name
from sgpm.p_code
where code_type = 'TransforNature'
and value = t.TRANSFORNATURE) "×ʲúËùÓÃÐÔÖÊ"
from olive.v$_ST_DisTransAsset t
where orgid = :1
and assetsstatus = decode(:2, null, 'S', :3, :4)
and length( :5)=7
) WHERE rownum <= :6 |
20qj7xd001w39 |
SELECT * FROM (SELECT row_.*, rownum rownum_ FROM( select name "Éú²ú±äѹÆ÷Ãû³Æ",
(select org_name
from sgpm.o_org
where org_no = orgid
And Rownum = 1) "¹©µçµ¥Î»",
(select (select (select name
from olive.v$_st_feeder
where obj_id = substr(o.s_04, 197, 64)
And Rownum = 1)
from olive.ol$_objects o
where obj_id = x.a
And Rownum = 1)
from olive.ol$_associations x
where b = substr(pathname, 2, 64)
And Rownum = 1) "ËùÊôÖ÷Ïß",
(select (select olive.getpathnamebypathid(o.s_04)
from olive.ol$_objects o
where obj_id = x.a
And Rownum = 1)
from olive.ol$_associations x
where b = substr(pathname, 2, 64)
And Rownum = 1) "Éú²ú±äѹÆ÷λÖÃ",
(select (select o.INSERVICEDATE
from olive.v$_st_powersystemresource o
where obj_id = x.a
And Rownum = 1)
from olive.ol$_associations x
where b = substr(pathname, 2, 64)
And Rownum = 1) "ͶÔËÈÕÆÚ",
(select (select (select (select org_name from sgpm.o_org where org_no=p_dept_no) from sgpm.o_dept where dept_no=o.o_15)
from olive.ol$_objects o
where obj_id = x.a
And Rownum = 1)
from olive.ol$_associations x
where b = substr(pathname, 2, 64)
And Rownum = 1) "ά»¤°à×é",
'10kV' "µçѹµÈ¼¶",
ratedCapacity "¶î¶¨ÈÝÁ¿(kVA)",
obj_id "Éú²úID",
(select name
from sgpm.p_code
where value = AssetsStatus
and code_type = 'AssetsState'
And Rownum = 1) "״̬",
CCBH "³ö³§±àºÅ",
(select name
from sgpm.p_code
where value = SBXH
and code_type = 'DisTransAssetXH'
And Rownum = 1) "É豸ÐͺÅ",
(Select Name
From Sgpm.p_Code p
Where Value = (Select Usetype
From Olive.V$_St_Distransformer
Where Obj_Id = (Select a
From Olive.Ol$_Associations
Where b = t.Obj_Id
and rownum = 1))
And p.Code_Type = 'UseType'
and rownum = 1) "ËùÓÃÐÔÖÊ",
(select name
from sgpm.p_code
where code_type = 'BDSB_ZCSSDW'
and value = t.ASSETNATURE) "×ʲúÐÔÖÊ",
decode((select (select ( (select 'Ïä±ä' from v$_ST_BoxStation where obj_id=substr(o.s_04, -129, 64))
)
from olive.ol$_objects o
where
obj_id = x.a
And Rownum = 1)
from olive.ol$_associations x
where b = substr(pathname, 2, 64)
And Rownum = 1), 'Ïä±ä', 'ÊÇ', '·ñ') "ÊÇ·ñÏä±ä",
(select name
from sgpm.p_code
where code_type = 'TransforNature'
and value = t.TRANSFORNATURE) "×ʲúËùÓÃÐÔÖÊ"
from olive.v$_ST_DisTransAsset t
where orgid = :1
and assetsstatus = decode(:2, null, 'S', :3, :4)
and length( :5)=7
) row_ WHERE rownum <= :6) WHERE rownum_ > :7 |
21z5a641zuy0m | Select Pc.Obj_Id,
Pc.Cls_Uri,
Pc.Voltagelevel,
Pc.Pathname,
Ass.Obj_Id Assetid,
Ass.Name Assetname,
Ass.Cls_Uri Asseturi,
Getnamepathbyidpath(Pc.Pathname || Ass.Pathname) Assetnamepath,
c.Cls_Uri Clsuri,
c.Cls_Disp_Name,
Ass.Assetsstatus,
Ass.Manufacturer,
Ass.Sbxh,
Ass.Inservicedate,
Ass.Code
From V$_St_Powersystemresource Pp,
V$_St_Powersystemresource Pc,
Ol$_Associations a,
V$_St_Asset Ass,
Ol$_Classes c
Where Pc.Pathname Like Pp.Pathname || '%'
And Ass.Pathname Like '\' || a.b || '%'
And Pp.Obj_Id =:1
And Pc.Obj_Id = a.a
And Ass.Cls_Uri = c.Cls_Uri
And a.Ast_Uri = 'OLASSOCIATIONTYPE://ST_PowerSystemResource_ST_Asset?A="OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource"&B="OLCLASS://Entity/ST_IdentifiedObject/ST_Asset"' and Pc.orgId=:2 and Ass.orgId=Pc.orgId
and ass.Assetsstatus in( 'S', 'W') and ass.CLS_URI in( 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/ST_ElectricalAsset/ST_SwitchAsset/ST_FuseAsset') |
244v8yhfs7urr | SELECT C.CLS_ID, C.CLS_URI,
C.PKG_URI, C.CLS_NAME,
C.CLS_DISP_NAME, C.CLS_INDEX,
C.CLS_LEVEL, C.CLS_LOGGABLE,
C.CLS_ABSTRACT, C.CLS_DOC,
C.CLS_SORT
FROM OL$_CLASSES C, OL$_ASSOCIATION_CONSTRAINTS AC
WHERE C.CLS_URI = AC.SIDE_B
AND C.CLS_SORT = 'T'
AND AC.SIDE_A = :1 |
2ym6hhaq30r73 | select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3 |
3ypmvj5df15za |
SELECT COUNT(1) cnt FROM( select name "Éú²ú±äѹÆ÷Ãû³Æ",
(select org_name
from sgpm.o_org
where org_no = orgid
And Rownum = 1) "¹©µçµ¥Î»",
(select (select (select name
from olive.v$_st_feeder
where obj_id = substr(o.s_04, 197, 64)
And Rownum = 1)
from olive.ol$_objects o
where obj_id = x.a
And Rownum = 1)
from olive.ol$_associations x
where b = substr(pathname, 2, 64)
And Rownum = 1) "ËùÊôÖ÷Ïß",
(select (select olive.getpathnamebypathid(o.s_04)
from olive.ol$_objects o
where obj_id = x.a
And Rownum = 1)
from olive.ol$_associations x
where b = substr(pathname, 2, 64)
And Rownum = 1) "Éú²ú±äѹÆ÷λÖÃ",
(select (select o.INSERVICEDATE
from olive.v$_st_powersystemresource o
where obj_id = x.a
And Rownum = 1)
from olive.ol$_associations x
where b = substr(pathname, 2, 64)
And Rownum = 1) "ͶÔËÈÕÆÚ",
(select (select (select (select org_name from sgpm.o_org where org_no=p_dept_no) from sgpm.o_dept where dept_no=o.o_15)
from olive.ol$_objects o
where obj_id = x.a
And Rownu
m = 1)
from olive.ol$_associations x
where b = substr(pathname, 2, 64)
And Rownum = 1) "ά»¤°à×é",
'10kV' "µçѹµÈ¼¶",
ratedCapacity "¶î¶¨ÈÝÁ¿(kVA)",
obj_id "Éú²úID",
(select name
from sgpm.p_code
where value = AssetsStatus
and code_type = 'AssetsState'
And Rownum = 1) "״̬",
CCBH "³ö³§±àºÅ",
(select name
from sgpm.p_code
where value = SBXH
and code_type = 'DisTransAssetXH'
And Rownum = 1) "É豸ÐͺÅ",
(Select Name
From Sgpm.p_Code p
Where Value = (Select Usetype
From Olive.V$_St_Distransformer
Where Obj_Id = (Select a
From Olive.Ol$_Associations
Where b = t.Obj_Id
and rownum = 1))
And p.Code_Type = 'UseType'
and rownum = 1) "ËùÓÃÐÔÖÊ",
(select name
from sgpm.p_code
where code_type = 'BDSB_ZCSSDW'
and value = t.ASSETNATURE) "×ʲúÐÔÖÊ",
decode((select (select ( (select 'Ïä±ä' from v$_ST_BoxStation where obj_id=substr(o.s_04, -129, 64))
)
from olive.ol$_objects o
where obj_id = x.a
And Rownum = 1)
from olive.ol$_associations x
where b = substr(pathname, 2, 64)
And Rownum = 1), 'Ïä±ä', 'ÊÇ', '·ñ') "ÊÇ·ñÏä±ä",
(select name
from sgpm.p_code
where code_type = 'TransforNature'
and value = t.TRANSFORNATURE) "×ʲúËùÓÃÐÔÖÊ"
from olive.v$_ST_DisTransAsset t
where orgid = :1
and assetsstatus = decode(:2, null, 'S', :3, :4)
and length( :5)=7
) |
449xyhjkn7apn | select * from v$_ST_EquipmentCategory where ( orgId = :1 ) and OBJ_ID in (select /*+ INDEX ( ol$_associations NK_OL$_REFS_URI_A ) */ ol$_associations.b obj_id from ol$_associations where ol$_associations.ast_uri = :2 and ol$_associations.a = :3 ) |
450w20twk6ku5 | BEGIN
OL$_RULE_CORE.CHECKNAMEMAIN(:1, :2, :3, :4, :5, :6, :7);
END; |
48cbp9fvjyc13 | select t.ID, t.linename, t.branchPoint location, t.wirepart name, t.yparam distWireType, t.WireType distWireTypeNew, t.unitResistance, t.unitReactance, t.sectionalArea, t.distWireMaterial, 'true' flag, t.TransformerID, round(t.jjzll, 4) jjzll, t.begPoleId, t.endPoleId from T_YPJC_ANALOYANALYSISDX_INFO t where t.TransformerID = :1
|
49qruxf8jhu57 | select a.*, b.org_name, c.org_name org_name_city from v_failure_record_query a, sgpm.o_org b , sgpm.o_org c where a.xjid = b.org_no AND SUBSTR(a.xjid, 1, 5) = c.ORG_NO and a.orgno like GETORGNO('1340313') order by a.gzbh desc |
4hn182nyc6xd5 | INSERT INTO T_YPJC_DISTLINESEGMENT
(id,
loss_id,
from_dist_pole_position_id,
to_dist_pole_position_id,
dist_line_segment_id,
distlinesegmentname,
linename,
location,
wirelength,
wire_type_code,
wire_type_name,
unitresistance,
unitreactance)
VALUES
(sys_guid(), :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12) |
4ydgzsjh9kb57 |
SELECT a.obj_id objid,
a.cls_uri,
a.orgid,
getorgnamebyorgno(orgid) org_name,
a.NAME linename,
b.id,
b.objname,
to_char(b.count_date, 'yyyy-mm') count_date,
b.active_power,
b.reactive_power,
b.actual_line_lose,
b.actual_line_lose_rate,
b.academic_line_lose,
b.academic_line_lose_rate,
b.algorithm,
b.count_date,
b.compute_date
FROM olive.v$_lowarea a
LEFT JOIN (SELECT id,
low_area_original_id,
org_no,
org_name,
objid,
objname,
deptid,
userid,
active_power,
reactive_power,
actual_line_lose,
actual_line_lose_rate,
academic_line_lose,
academic_line_lose_rate,
calcalgo,
compute_date,
calcresult,
count_date,
algorithm,
row_number() over(PARTITION BY low_area_original_id ORDER BY count_date DESC) count_date_ord
FROM t_ypjc_dy_linelose l
WHERE NOT EXISTS (SELECT 1
FROM t_ypjc_low_plan_loss_relation r
WHERE r.loss_id = l.id)
) b ON a.obj_id = b.low_area_original_id
AND b.count_date_ord = 1
WHERE a.resourcestatus = :1
AND a.orgid = :2
ORDER BY compute_date |
4za9rvjqxptak | SELECT COUNT(1) cnt FROM( Select (Select Org_Name From Sgpm.o_Org Where Org_No = Substr(t.Orgid, 1, 5)) "Êе¥Î»",
(Select Org_Name From Sgpm.o_Org Where Org_No = Substr(t.Orgid, 1, 7)) "ÏØµ¥Î»",
(Select Org_Name From Sgpm.o_Org Where Org_No = t.Orgid) "¹©µçËù",
Name "Ïß·Ãû³Æ",
(Select Name
From v$_st_dyline
Where Obj_Id = Substr(t.Pathname, -129, 64)) "Éϼ¶Ïß·",
Getpathnamebypathid(Substr(t.Pathname, 1, Length(t.Pathname) - 65)) "Éϼ¶Ïß·λÖÃ",
t.Tconnectname "T½Ó¸ËËþ±àºÅ"
From olive.v$_st_dyline t
Where t.RESOURCESTATUS = 'E'
And Length(t.Pathname) > 390
And Orgid = :1
and length(:2) > 7
and (t.Tconnectid Is Null or not exists
(select 1
from olive.ol$_objects p
where p.OBJ_ID = t.Tconnectid
and p.s_04 like
Substr(t.Pathname, 1, Length(t.Pathname) - 65) || '%'))) |
572fbaj0fdw2b | select output from table(dbms_workload_repository.awr_report_html( :dbid,
:inst_num,
:bid, :eid,
:rpt_options )) |
598k07tzg7tud | Select
Ass.Obj_Id,
ass.CLS_URI,
Ass.Name,
Ass.Ratedcapacity,
(Select Name
From Sgpm.p_Code
Where Code_Type = 'DisTransAssetXH'
And Value = Ass.Sbxh) Sbxh,
pc.Pathname Pathid,
Olive.Getpathnamebypathid(pc.Pathname) Pathname,
Ass.Assetsstatus,
Ass.Orgid,
Ass.CODE
From olive.v$_st_powersystemresource pp,
Olive.V$_St_Distransformer Pc,
Olive.V$_St_Distransasset Ass,
Olive.Ol$_Associations a
Where Pc.Pathname Like pp.PATHNAME||'%'
And pp.OBJ_ID = :1
And Ass.Pathname Like '\' || a.b || '%'
And Pc.Obj_Id = a.a
And Ass.Assetsstatus In (:2, :3)
And Ass.Orgid = Pc.Orgid
And Pc.Orgid = :4 and pc.RESOURCESTATUS = 'E' |
5bf742hjadsqf | select * from olive.v$_ST_CableAssetModel
|
5bhhxz06fvgnk |
SELECT OBJ_ID,
NAME,
A.CLS_URI,
A.PATHNAME,
C.CLS_DISP_NAME,
(CASE
WHEN A.CLS_URI LIKE
'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/%' THEN
(SELECT GETPATHNAMEBYPATHID(P1.PATHNAME || A.PATHNAME)
FROM OL$_ASSOCIATIONS ASS,
V$_ST_POWERSYSTEMRESOURCE P1,
V$_ST_POWERSYSTEMRESOURCE P2
WHERE ASS.AST_URI =
'OLASSOCIATIONTYPE://ST_PowerSystemResource_ST_Asset?A="OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource"&B="OLCLASS://Entity/ST_IdentifiedObject/ST_Asset"'
AND ASS.B = SUBSTR(A.PATHNAME, 2, 64)
AND ASS.A = P1.OBJ_ID
AND P1.PATHNAME LIKE P2.PATHNAME || '%'
AND ROWNUM = 1 AND P2.OBJ_ID IN (:1))
ELSE
GETPATHNAMEBYPATHID(PATHNAME)
END) PATHNAMEVALUE
FROM V$_ST_IDENTIFIEDOBJECT A, OLIVE.OL$_CLASSES C
WHERE C.CLS_URI = A.CLS_URI
AND OBJ_ID IN(:2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :
97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108, :109, :110, :111, :112, :113, :114, :115, :116, :117, :118, :119, :120, :121, :122, :123, :124, :125, :126, :127, :128, :129, :130, :131, :132, :133, :134, :135, :136, :137, :138, :139, :140, :141, :142, :143, :144, :145, :146, :147, :148, :149, :150, :151, :152, :153, :154, :155, :156, :157, :158, :159, :160, :161, :162, :163, :164, :165, :166, :167, :168, :169, :170, :171, :172, :173, :174, :175, :176, :177, :178, :179, :180, :181, :182, :183, :184, :185, :186, :187, :188, :189, :190, :191, :192, :193, :194, :195, :196, :197, :198, :199, :200, :201, :202, :203, :204, :205, :206, :207, :208, :209, :210, :211, :212, :213, :214, :215, :216, :217, :218, :219, :220, :221, :222, :223, :224, :225, :226, :227, :228, :229, :230, :231, :232, :233, :234, :235, :236, :237, :238, :239, :240, :241, :242, :243, :244, :245, :246, :247, :248, :249, :250, :251, :252, :253, :254, :255, :256, :257, :258, :259, :260, :261, :262, :263, :264, :265, :266, :267, :268, :269, :270, :271, :272, :273, :274, :275, :276, :277, :278, :279, :280, :281, :282, :283, :284, :285, :286, :287, :288, :289, :290, :291, :292, :293, :294, :295, :296, :297, :298, :299, :300, :301, :302, :303, :304, :305, :306, :307, :308, :309, :310, :311, :312, :313, :314, :315, :316, :317, :318, :319, :320, :321, :322, :323, :324, :325, :326, :327, :328, :329, :330, :331, :332, :333, :334, :335, :336, :337, :338, :339, :340, :341, :342, :343, :344, :345, :346, :347
, :348, :349, :350, :351, :352, :353, :354, :355, :356, :357, :358, :359, :360, :361, :362, :363, :364, :365, :366, :367, :368, :369, :370, :371, :372, :373, :374, :375, :376, :377, :378, :379, :380, :381, :382, :383, :384, :385, :386, :387, :388, :389, :390, :391, :392, :393, :394, :395, :396, :397, :398, :399, :400, :401, :402, :403, :404, :405, :406, :407, :408, :409, :410, :411, :412, :413, :414, :415, :416, :417, :418, :419, :420, :421, :422, :423, :424, :425, :426, :427, :428, :429, :430, :431, :432, :433, :434, :435, :436, :437, :438, :439, :440, :441, :442, :443, :444, :445, :446, :447, :448, :449, :450, :451, :452, :453, :454, :455, :456, :457, :458, :459, :460, :461, :462, :463, :464, :465, :466, :467, :468, :469, :470, :471, :472, :473, :474, :475, :476, :477, :478, :479, :480, :481, :482, :483, :484, :485, :486, :487, :488, :489, :490, :491, :492, :493, :494, :495, :496, :497, :498, :499, :500, :501, :502, :503, :504, :505, :506, :507, :508, :509, :510, :511, :512, :513, :514, :515, :516, :517, :518, :519, :520, :521, :522, :523, :524, :525, :526, :527, :528, :529, :530, :531, :532, :533, :534, :535, :536, :537, :538, :539, :540, :541, :542, :543, :544, :545, :546, :547, :548, :549, :550, :551, :552, :553, :554, :555, :556, :557, :558, :559, :560, :561, :562, :563, :564, :565, :566, :567, :568, :569, :570, :571, :572, :573, :574, :575, :576, :577, :578, :579, :580, :581, :582, :583, :584, :585, :586, :587, :588, :589, :590, :591, :592, :593, :594, :595, :596, :597
, :598, :599, :600, :601, :602, :603, :604, :605, :606, :607, :608, :609, :610, :611, :612, :613, :614, :615, :616, :617, :618, :619, :620, :621, :622, :623, :624, :625, :626, :627, :628, :629, :630, :631, :632, :633, :634, :635, :636, :637, :638, :639, :640, :641, :642, :643, :644, :645, :646, :647, :648, :649, :650, :651, :652, :653, :654, :655, :656, :657, :658, :659, :660, :661, :662, :663, :664, :665, :666, :667, :668, :669, :670, :671, :672, :673, :674, :675, :676, :677, :678, :679, :680, :681, :682, :683, :684, :685, :686, :687, :688, :689, :690, :691, :692, :693, :694, :695, :696, :697, :698, :699, :700, :701, :702, :703, :704, :705, :706, :707, :708, :709, :710, :711, :712, :713, :714, :715, :716, :717, :718, :719, :720, :721, :722, :723, :724, :725, :726, :727, :728, :729, :730, :731, :732, :733, :734, :735, :736, :737, :738, :739, :740, :741, :742, :743, :744, :745, :746, :747, :748, :749, :750, :751, :752, :753, :754, :755, :756, :757, :758, :759, :760, :761, :762, :763, :764, :765, :766, :767, :768, :769, :770, :771, :772, :773, :774, :775, :776, :777, :778, :779, :780, :781, :782, :783, :784, :785, :786, :787, :788, :789, :790, :791, :792, :793, :794, :795, :796, :797, :798, :799, :800, :801)
ORDER BY A.CLS_URI , A.PATHNAME |
5n9d2rmutsfqv | select t.* from ol$_attr_categories t where t.cls_uri=:1 order by t.cat_index |
5qr55krh9dkx5 |
select APPLY_ID, APPLY_CD, APPLY_DATE, APPLICANT_CD, APPLICANT, APPLY_UNIT_CD, APPLY_UNIT, REPAIR_UNIT_CD, REPAIR_UNIT, PLAN_TO_CUT, WEEK_PLAN_CD, WORK_LEADER_CD, WORK_LEADER, APPLY_STOP_BEGIN_DATE, APPLY_STOP_END_DATE, STOP_TARGET_ID, STOP_TARGET, STOP_ASSETS_ID, STOP_ASSETS, STOP_SCOPE, WORK_CONTENT, WIRING_CHART, CHANGED_WIRING_CHART, HANDLER_CD, HANDLER, AUDITOR_CD, AUDITOR, APPROVAL_STOP_BEGIN_DATE, APPROVAL_STOP_END_DATE, DISTRICT_DISP_FASHION, DISTRICT_DISP_GUARD, DISTRICT_DISP_APPROVE, FASHION, FASHION_AUDITOR_CD, FASHION_AUDITOR, GUARD, GUARD_AUDITOR_CD, GUARD_AUDITOR, APPROVAL, APPROVER_CD, APPROVER, RECEIVER_CD, RECEIVER, WORKING_BEGIN_DATE, DELEGATE_CD, DELEGATE, BEGIN_DISPATCHER_CD, BEGIN_DISPATCHER, WORKING_END_DATE, REPORTER_CD, REPORTER, END_DISPATCHER_CD, END_DISPATCHER, REAUDITOR_CD, REAUDITOR, DELAY_APPLY_BEGIN_DATE, DELAY_APPLY_END_DATE, DELAY_BEGIN_DATE, DELAY_END_DATE, APPROVAL_BEGIN_DATE, APPROVAL_END_DATE, REPAIR_BEGIN_DATE, REPAIR_END_DATE, DELAY_APPLICANT_CD, DELAY_APPLICANT, DELAY_APPROVER_CD, DELAY_APPROVER, DELAY_REASON, MEMO, LAST_UPDATE_DATE, LAST_UPDATER_CD, LAST_UPDATER, CREATE_DATE, CREATER_CD, CREATER, ORG_NO, ORG_NAME, DEL_FLG , action_url, actionname, activity_name, HANDLE_AUDIT_DATE, FASHION_AUDIT_DATE, FASHION_APPROVAL_BEGIN_DATE, FASHION_APPROVAL_END_DATE, GUARD_AUDIT_DATE, APPROVE_AUDIT_DATE from V_POWERCUT_APPLY_QUERY a where 1=1 and a.WEEK_PLAN_CD =:1
|
5v8y4xqjc73kv | SELECT Q1.B OBJ_ID
FROM OLIVE.OL$_QUOTEASSOCIATIONS Q1, OLIVE.OL$_QUOTEASSOCIATIONS Q2
WHERE Q1.AST_URI = Q2.AST_URI AND Q1.A = Q2.A
AND Q2.B = :1 |
5wfhpq886xacr | SELECT /*+index(t, NK_OL$_REFS_URI_A)*/ A, B OBJ_ID, (SELECT S_01 FROM OL$_OBJECTS WHERE OBJ_ID = B) NAME FROM OL$_ASSOCIATIONS T WHERE AST_URI = :B2 AND A = :B1 AND SUBSTR(B, 1, 32) IN (SELECT (SELECT CLS_ID FROM OL$_CLASSES WHERE CLS_URI = C.CLS_URI) CLS_ID FROM OL$_CLSNAME_DEFS C WHERE EXISTS (SELECT 1 FROM OL$_CLSRULE_DEFS D WHERE D.MAIN_ID = C.MAIN_ID AND EXISTS (SELECT 1 FROM OL$_RULE_DEFS WHERE UPPER(UP_COL) = 'NAME' AND RULE_TYPE = 'C2' AND RULE_ID = D.RULE_ID)) AND EQUIPMENT_SORT = OL$_RULE_CORE.GETEQUSORT(:B1 )) |
646v5z184310m | select t.s_01 from olive.ol$_objects t where t.obj_id= :1 |
673hs7hb3w9g1 | Select Pc.Obj_Id,
Pc.Cls_Uri,
Pc.Voltagelevel,
Pc.Pathname,
Ass.Obj_Id Assetid,
Ass.Name Assetname,
Ass.Cls_Uri Asseturi,
Getnamepathbyidpath(Pc.Pathname || Ass.Pathname) Assetnamepath,
c.Cls_Uri Clsuri,
c.Cls_Disp_Name,
Ass.Assetsstatus,
Ass.Manufacturer,
Ass.Sbxh,
Ass.Inservicedate,
Ass.Code
From V$_St_Powersystemresource Pp,
V$_St_Powersystemresource Pc,
Ol$_Associations a,
V$_St_Asset Ass,
Ol$_Classes c
Where Pc.Pathname Like Pp.Pathname || '%'
And Ass.Pathname Like '\' || a.b || '%'
And Pp.Obj_Id =:1
And Pc.Obj_Id = a.a
And Ass.Cls_Uri = c.Cls_Uri
And a.Ast_Uri = 'OLASSOCIATIONTYPE://ST_PowerSystemResource_ST_Asset?A="OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource"&B="OLCLASS://Entity/ST_IdentifiedObject/ST_Asset"' and Pc.orgId=:2 and Ass.orgId=Pc.orgId
and ass.Assetsstatus in( 'S', 'W') and ass.CLS_URI in( 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/ST_AssetContainer/ST_Structure/DYPole', 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/ST_ElectricalAsset/ST_LinearConductorAsset/DYLinearConductorAsset', 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/ST_ElectricalAsset/ST_LinearConductorAsset/DYCableAsset') |
6f4zjjxqztymw | select DECODE(SFCQCQCS, 'T', 'ÊÇ', '·ñ') SFCQCQCS, decode(ysbdd, 'T', 'ÊÇ', '·ñ') ysbddchar, decode(t.JSZXXQ, 'J', 'ÊÇ', '·ñ') jsxq, decode(sfsc, 'T', 'ÊÇ', '·ñ') sfscchar, case when t.JSZXXQ = 'J' then '¼´Ê±Ïûȱ' when t.JSZXXQ = 'Z' then '×ÔÐÐÏûȱ' else '·ñ' end jszxxqchar, t.* from v_qx_query2 t where 1=1 and t.fxrq >=to_date('1995-03-01 00:00:01', 'yyyy-mm-dd hh24:mi:ss') and t.fxrq<=to_date('2013-03-31 23:59:59', 'yyyy-mm-dd hh24:mi:ss') and t.ssjdm like GETORGNO('1340123') order by ID desc |
6fn21cpfwmbmw | INSERT INTO T_EQUIMODIFY_DETAIL WITH TEMP_ASSET_S AS (SELECT AA.OBJ_ID FROM OLIVE.V$_ST_ASSET AA WHERE AA.ORGID = :B1 AND AA.OBJ_ID IN (SELECT T.B FROM OLIVE.V$_ST_POWERSYSTEMRESOURCE P, OLIVE.OL$_OBJECTS_TEMP_TAB P1, OLIVE.OL$_ASSOCIATIONS T WHERE T.A = P.OBJ_ID AND P.PATHNAME LIKE P1.S_04 || '%' AND P.ORGID = :B1 )), TEMP_ASSET_R AS (SELECT AA.OBJ_ID FROM OLIVE.V$_ST_ASSET AA WHERE AA.ORGID = :B1 AND AA.OBJ_ID IN (SELECT T.B FROM OLIVE.V$_ST_POWERSYSTEMRESOURCE P, OLIVE.OL$_OBJECTS_TEMP_TAB P1, OLIVE.OL$_ASSOCIATIONS_RETIRE T WHERE T.A = P.OBJ_ID AND P.PATHNAME LIKE P1.S_04 || '%' AND P.ORGID = :B1 )), TEMP_ASSET_FIRSTALL AS (SELECT OBJ_ID FROM TEMP_ASSET_S UNION ALL SELECT OBJ_ID FROM TEMP_ASSET_R) SELECT :B3 , X.OBJ_ID, X.CLS_URI, X.NAME, X.VOLTAGELEVEL, X.INSERVICEDATE, X.CREATORID, X.CREATEDATE, X.LASTUPDATEID, X.LASTUPDATEDATE, X.ASSETSSTATUS, '', X.ORGID, DECODE(X.LASTUPDATEDATE, X.CREATEDATE, 'A', DECODE(X.ASSETSSTATUS, 'R', 'D', 'U')) OPERATOR_TYPE FROM OLIVE.V$_ST_ASSET X WHERE X.OBJ_ID IN (SELECT OBJ_ID FROM TEMP_ASSET_FIRSTALL) AND TO_CHAR(X.LASTUPDATEDATE, 'YYYY-MM-DD') = TO_CHAR(SYSDATE, 'YYYY-MM-DD') AND X.LASTUPDATEID = :B2 AND X.ORGID = :B1 |
6pcrpqf5dkunf | select /*+ index(o PK_OL$_OBJECTS) */ * from v$_DYPolePosition o where obj_id=:1 |
6xjqy1675jdyr | select * from v$_ST_EquipmentContainer where ( orgId = :1 and ResourceStatus = :2 ) and OBJ_ID in (select /*+ INDEX ( ol$_associations NK_OL$_REFS_URI_A ) */ ol$_associations.b obj_id from ol$_associations where ol$_associations.ast_uri = :3 and ol$_associations.a = :4 ) order by name |
72ffsqhv7dd6h |
select T128047.KGLX as c4,
T121580.BDSMC as c5,
T128574.HH as c6,
T128047.MIN_VALUE as c8,
T128047.AVG_VALUE as c9,
T128047.MAX_VALUE as c10,
T121580.XJDM as c11,
T121580.DSJDM as c12
from
(select t.dd, t.did, t.hh, t.hid from d_rq_by t where t.did = to_char(sysdate, 'yyyymmdd') ) T128574,
D_SB_DW$BDZ$ZB T121580,
F_SCADA_BDZ_VALUE T128047
where ( T121580.BDSDM = T128047.BDZDM and T128047.DATAID = T128574.HID and T121580.DSJMC = 'ºªµ¦¹©µç¹«Ë¾' and T121580.XJMC = '·ÊÏçÏØ¹©µç¹«Ë¾' and T128047.KGLX = 'Ïß·¿ª¹Ø' and (T121580.DSJDM in ('1340220') or T121580.XJDM in (substr('1340220' , 1 , 7), '1340220')) and T128047.DWDM in ('1340220') ) |
7jm90h66ramq2 | select DECODE(SFCQCQCS, 'T', 'ÊÇ', '·ñ') SFCQCQCS, decode(ysbdd, 'T', 'ÊÇ', '·ñ') ysbddchar, decode(t.JSZXXQ, 'J', 'ÊÇ', '·ñ') jsxq, decode(sfsc, 'T', 'ÊÇ', '·ñ') sfscchar, case when t.JSZXXQ = 'J' then '¼´Ê±Ïûȱ' when t.JSZXXQ = 'Z' then '×ÔÐÐÏûȱ' else '·ñ' end jszxxqchar, t.* from v_qx_query2 t where 1=1 and (t.ysxqxzdm='55' or t.ysxqxzdm='54' or t.ysxqxzdm='57') and t.fxrq >=to_date('1995-03-01 00:00:01', 'yyyy-mm-dd hh24:mi:ss') and t.fxrq<=to_date('2013-03-31 23:59:59', 'yyyy-mm-dd hh24:mi:ss') and t.ssjdm like GETORGNO('1340123') order by ID desc |
7vzpyu7p1t79j |
select APPLY_ID, APPLY_CD, APPLY_DATE, APPLICANT_CD, APPLICANT, APPLY_UNIT_CD, APPLY_UNIT, REPAIR_UNIT_CD, REPAIR_UNIT, PLAN_TO_CUT, WEEK_PLAN_CD, WORK_LEADER_CD, WORK_LEADER, APPLY_STOP_BEGIN_DATE, APPLY_STOP_END_DATE, STOP_TARGET_ID, STOP_TARGET, STOP_ASSETS_ID, STOP_ASSETS, STOP_SCOPE, WORK_CONTENT, WIRING_CHART, CHANGED_WIRING_CHART, HANDLER_CD, HANDLER, AUDITOR_CD, AUDITOR, APPROVAL_STOP_BEGIN_DATE, APPROVAL_STOP_END_DATE, DISTRICT_DISP_FASHION, DISTRICT_DISP_GUARD, DISTRICT_DISP_APPROVE, FASHION, FASHION_AUDITOR_CD, FASHION_AUDITOR, GUARD, GUARD_AUDITOR_CD, GUARD_AUDITOR, APPROVAL, APPROVER_CD, APPROVER, RECEIVER_CD, RECEIVER, WORKING_BEGIN_DATE, DELEGATE_CD, DELEGATE, BEGIN_DISPATCHER_CD, BEGIN_DISPATCHER, WORKING_END_DATE, REPORTER_CD, REPORTER, END_DISPATCHER_CD, END_DISPATCHER, REAUDITOR_CD, REAUDITOR, DELAY_APPLY_BEGIN_DATE, DELAY_APPLY_END_DATE, DELAY_BEGIN_DATE, DELAY_END_DATE, APPROVAL_BEGIN_DATE, APPROVAL_END_DATE, REPAIR_BEGIN_DATE, REPAIR_END_DATE, DELAY_APPLICANT_CD, DELAY_APPLICANT, DELAY_APPROVER_CD, DELAY_APPROVER, DELAY_REASON, MEMO, LAST_UPDATE_DATE, LAST_UPDATER_CD, LAST_UPDATER, CREATE_DATE, CREATER_CD, CREATER, ORG_NO, ORG_NAME, DEL_FLG, (SELECT O.ORG_NAME FROM SGPM.O_ORG O WHERE O.ORG_NO=SUBSTR(A.ORG_NO, 1, 7)) ORG_NAMES , action_url, actionname, activity_name, HANDLE_AUDIT_DATE, FASHION_AUDIT_DATE, FASHION_APPROVAL_BEGIN_DATE, FASHION_APPROVAL_END_DATE, GUARD_AUDIT_DATE, APPROVE_AUDIT_DATE from V_POWERCUT_APPLY_QUERY a where 1=1 and trunc(a.fashion
_approval_begin_date, 'DD') >= to_date(:1, 'yyyy-MM-dd') and trunc(a.fashion_approval_begin_date, 'DD') <= to_date(:2, 'yyyy-MM-dd') and a.org_no like GETORGNO(:3) |
7xgzx0zrnt0fc | select /*+ index(o PK_OL$_OBJECTS) */ * from v$_ST_DYLine o where obj_id=:1 |
7xn6xppmpg9u7 | SELECT *
FROM (SELECT D.OBJ_ID,
D.CLS_URI,
D.NAME,
GETNAMEPATHBYIDPATH(D.PATHNAME) PATHNAME,
C.CLS_DISP_NAME DISNAME
FROM (SELECT ASS.B
FROM OLIVE.OL$_ASSOCIATIONS ASS
START WITH ASS.A = :1 ---- ¶¥²ãÉ豸ÈÝÆ÷id
CONNECT BY PRIOR ASS.B = A) E,
OLIVE.V$_ST_POWERSYSTEMRESOURCE D,
OLIVE.OL$_CLASSES C
WHERE D.OBJ_ID = E.B
AND D.CLS_URI IN(:2)
AND C.CLS_URI = D.CLS_URI
AND D.RESOURCESTATUS = 'E'
AND D.ORGID =:3 ) E
ORDER BY E.PATHNAME |
8b9zc43w360qt | SELECT O_28 partitionField FROM ol$_objects t WHERE t.obj_id=:1 |
8d3y3sqaj9f3s |
SELECT * FROM (SELECT row_.*, ROWNUM rownum_ FROM ( SELECT a.process_type, a.process_no, a.process_title, a.app_no, a.taskid, a.act_name, a.rcv_time, a.finish_time, a.alarm_date, a.due_time,
a.cur_state status_code, a.lock_emp_no, a.lock_time, a.org_no, a.overreason, a.worklist_type, a.alarm_time_limit, a.time_limit, a.task_color, a.back_reason, handle_rslt, a.busi_type_code, a.srv_mode
, CASE WHEN a.due_time < SYSDATE THEN 'Y' ELSE 'N' END isovertimer, CASE WHEN a.alarm_date < SYSDATE THEN 'Y' ELSE 'N' END isalarmtimer, a.cons_no, a.cons_name, a.elec_addr, a.sect_no, a.sect_name, a.sect_remark, a.chk_subject_no, a.chk_type, a.chk_name, a.chk_prio
, a.exam_chk_type, a.equip_categ, a.equip_model, a.assign_date, a.qty, a.subs_no, a.subs_name, a.subs_addr
, a.cust_no, a.cust_name, a.cust_use_addr, a.link_addr, a.link_name, a.link_tel, a.srv_channel, a.call_no, a.call_content, a.selbuy_equip, a.crm_cust_no, a.crm_cust_name, a.crm_resume, a.exam_remark, a.busi_data, a.start_user, a.distribute_dept, a.dm_task_type, a.app_contract_cap, a.t_contract_cap, a.volt_code, a.process_color, a.resume_time, a.user_org_no, a.terminal_addr, a.fault_addr, a.fault_property , a.scip_register_no, a.scip_cons_no, a.scip_busi_type, a.scip_srv_content, a.scip_req_time FROM wf_amber.v_indysp_worklist_cur a, wf_amber.indysp_task_user_cur b
WHERE a.taskid = b.taskid AND a.app_no = b.app_no
AND a.org_no = b.process_org_no
AND b.user_no = :1 AND b.user_
dept_no = :2
AND b.user_org_no = :3 AND a.cur_state NOT IN( 'WAIT', 'BACKWAIT') AND ( a.lock_emp_no = :4 OR a.lock_emp_no IS NULL ) ORDER BY a.rcv_time DESC ) row_ WHERE ROWNUM <:5) WHERE rownum_ >=:6 |
95jvxjj84rcct | select /*+ index(o PK_OL$_OBJECTS) */ * from v$_MeterBox o where obj_id=:1 |
964zgsudcdac7 | SELECT D.ATTR_URI FROM OL$_ATTR_DEFS D WHERE D.CLS_URI = :B2 AND D.ATTR_NAME = :B1 |
9g4jrwq86jnb7 | BEGIN
OL$_RULE_CORE.CHECKANDUPDATELOWERNAME(:1);
END; |
9v06ad27zwf4x | Select NAME From v$_ST_TransmisPolePosition Where obj_id =:Upobjid |
9vrbr3jjprusn | SELECT B OBJ_ID, (SELECT S_01 FROM OL$_OBJECTS WHERE OBJ_ID = B) NAME FROM (SELECT T.*, LEVEL FROM OL$_ASSOCIATIONS T WHERE AST_URI = :B2 AND SUBSTR(B, 1, 32) != SUBSTR(:B1 , 1, 32) AND SUBSTR(DECODE(A, :B1 , '1', A), 1, 32) != SUBSTR(:B1 , 1, 32) START WITH A = :B1 CONNECT BY PRIOR B = A) WHERE SUBSTR(B, 1, 32) IN (SELECT (SELECT CLS_ID FROM OL$_CLASSES WHERE CLS_URI = C.CLS_URI) CLS_ID FROM OL$_CLSNAME_DEFS C WHERE EXISTS (SELECT 1 FROM OL$_CLSRULE_DEFS D WHERE D.MAIN_ID = C.MAIN_ID AND EXISTS (SELECT 1 FROM OL$_RULE_DEFS WHERE UP_TARGET_CLS = :B3 AND UPPER(UP_COL) = 'NAME' AND RULE_TYPE = 'C' AND RULE_ID = D.RULE_ID))) START WITH A = :B1 CONNECT BY PRIOR B = A |
9yyb7wvndk114 | select * from v$_ST_DYLine where ( orgId = :1 and ResourceStatus = :2 ) and OBJ_ID in (select /*+ INDEX ( ol$_associations NK_OL$_REFS_URI_A ) */ ol$_associations.b obj_id from ol$_associations where ol$_associations.ast_uri = :3 and ol$_associations.a = :4 ) order by cls_uri |
a41yvpfth003x | select * from v$_ST_Equipment where ( orgId = :1 and RESOURCESTATUS=:2) and OBJ_ID in (select /*+ INDEX ( ol$_associations NK_OL$_REFS_URI_A ) */ ol$_associations.b obj_id from ol$_associations where ol$_associations.ast_uri = :3 and ol$_associations.a = :4 ) |
ab0n17bxfj28d | SELECT *
FROM (SELECT D.OBJ_ID,
D.CLS_URI,
D.NAME,
GETNAMEPATHBYIDPATH(D.PATHNAME) PATHNAME,
C.CLS_DISP_NAME DISNAME
FROM (SELECT ASS.B
FROM OLIVE.OL$_ASSOCIATIONS ASS
START WITH ASS.A = :1 ---- ¶¥²ãÉ豸ÈÝÆ÷id
CONNECT BY PRIOR ASS.B = A) E,
OLIVE.V$_ST_POWERSYSTEMRESOURCE D,
OLIVE.OL$_CLASSES C
WHERE D.OBJ_ID = E.B
AND D.CLS_URI IN(:2)
AND D.NAME LIKE :3
AND C.CLS_URI = D.CLS_URI
AND D.RESOURCESTATUS = 'E'
AND D.ORGID =:4 ) E
ORDER BY E.PATHNAME |
ac4pb7ypdb95a | select count(l.log_machine_ip) from indy_online_user l, indy_user u where l.log_link_id !=:1 and l.log_web_path=:2 and l.log_user_id = u.user_id and u.user_name = :3 |
apd7t7sfn2wxd | SELECT Getnamepathbyidpath(Pc.Pathname || Ass.Pathname) pathName, Pc.OBJ_ID resourceId FROM V$_ST_ASSET Ass, OL$_ASSOCIATIONS O, V$_ST_POWERSYSTEMRESOURCE Pc
WHERE Ass.OBJ_ID =:1 AND O.B = SUBSTR(Ass.PATHNAME, 2, 64)
AND Pc.OBJ_ID = O.A AND O.AST_URI =:2 |
avjzuwm5npxv7 | select * from indy_menu where menu_id in ( select menu_id from indy_menu start with menu_id in ( select n.menu_id from indy_menu n where menu_state = '01' and n.action_normal = 'T' and n.action_id in ( select ua.action_id from indy_user_action ua where ua.user_id = :1 ) union all select m.menu_id from indy_menu m where menu_state = '01' and m.action_normal = 'T' and m.action_authorized = 'F' and m.action_id is not null ) connect by menu_id = prior menu_parent_id ) and menu_kind in ('MenuFolder', 'MenuItem') and decode(:2, menu_parent_id, 1, menu_grant_id, 1, 0) = 1 and menu_state = :3 order by menu_index |
aw6gj3r2syaxs | select interdata.area_code, interdata.area_name, interdata.sub_area_code, interdata.sub_area_name, to_char(Min(interdata.import_time), 'yyyy-mm-dd hh24:mi:ss') as fartime, to_char(Max(interdata.import_time), 'yyyy-mm-dd hh24:mi:ss') as neartime, sum(1) As sczcs, sum(Case When interdata.handle_flag = '2' Then 1 When (interdata.handle_flag = '3' or interdata.handle_flag = '4') Then 0 End) as sccgcs, sum(Case When (interdata.handle_flag = '0' or interdata.handle_flag = '1') Then 1 When (interdata.handle_flag = '2' or interdata.handle_flag = '3' or interdata.handle_flag = '4') Then 0 End) as clzzcs, sum(Case When interdata.handle_flag = '2' Then 0 When (interdata.handle_flag = '3' or interdata.handle_flag = '4') Then 1 End) as yccs from scada.scada_interface_data_bd interData where 1=1 and interData.area_code = 'dqid' Group By interdata.area_code, interdata.area_name, interdata.sub_area_code, interdata.sub_area_name order by interdata.area_code, interdata.sub_area_code |
awvtdy3vc6fum | SELECT codeId, codeSortId, parentCodeId, codeType, orgNo, value, name, dispSn, content1, content2, content3, content4, content5 FROM (SELECT '' codeId, '' codeSortId, p_code parentCodeId, code_type codeType, org_no orgNo, value, name, disp_sn dispSn, content1, content2, content3, content4, content5 FROM v_sp_cache_code) WHERE codeType=:1 |
b0mb9f2wdgnrk | select /*+ index(o PK_OL$_OBJECTS) */ * from v$_LowArea o where obj_id=:1 |
bnaq6cxbzqy6u | SELECT * FROM ( Select (Select Org_Name From Sgpm.o_Org Where Org_No = Substr(t.Orgid, 1, 5)) "Êе¥Î»",
(Select Org_Name From Sgpm.o_Org Where Org_No = Substr(t.Orgid, 1, 7)) "ÏØµ¥Î»",
(Select Org_Name From Sgpm.o_Org Where Org_No = t.Orgid) "¹©µçËù",
Name "µ¼ÏßÃû³Æ",
Getpathnamebypathid((Select pathname
From v$_st_dyline
Where Obj_Id = (select a
from olive.ol$_associations
where b = t.OBJ_ID
and rownum = 1))) "µÍѹÏß·λÖÃ"
From olive.v$_DYLinearConductorAsset t
Where t.ASSETSSTATUS = 'S'
and (not exists
(select 1 from olive.v$_DYPolePosition p where p.OBJ_ID = t.FROMPOLE) or
not exists
(select 1 from olive.v$_DYPolePosition p where p.OBJ_ID = t.TOPOLE))
And Orgid = :1
and length(:2) > 7 ) WHERE rownum <= :3 |
bqbmpc6p2anhj | Select Pc.Obj_Id,
Pc.Cls_Uri,
Pc.Voltagelevel,
Pc.Pathname,
Ass.Obj_Id Assetid,
Ass.Name Assetname,
Ass.Cls_Uri Asseturi,
Getnamepathbyidpath(Pc.Pathname || Ass.Pathname) Assetnamepath,
c.Cls_Uri Clsuri,
c.Cls_Disp_Name,
Ass.Assetsstatus,
Ass.Manufacturer,
Ass.Sbxh,
Ass.Inservicedate,
Ass.Code
From V$_St_Powersystemresource Pp,
V$_St_Powersystemresource Pc,
Ol$_Associations a,
V$_St_Asset Ass,
Ol$_Classes c
Where Pc.Pathname Like Pp.Pathname || '%'
And Ass.Pathname Like '\' || a.b || '%'
And Pp.Obj_Id =:1
And Pc.Obj_Id = a.a
And Ass.Cls_Uri = c.Cls_Uri
And a.Ast_Uri = 'OLASSOCIATIONTYPE://ST_PowerSystemResource_ST_Asset?A="OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource"&B="OLCLASS://Entity/ST_IdentifiedObject/ST_Asset"' and Pc.orgId=:2 and Ass.orgId=Pc.orgId
and ass.Assetsstatus in( 'S', 'W') and ass.CLS_URI in( 'OLCLASS://Entity/ST_IdentifiedObject/ST_Asset/ST_ElectricalAsset/ST_LinearConductorAsset/DYLinearConductorAsset') |
bsm6gmajgmhuu | select * from indy_menu where menu_id in ( select menu_id from indy_menu start with menu_id in ( select n.menu_id from indy_menu n where menu_state = '01' and n.action_normal = 'T' and n.action_id in ( select ua.action_id from indy_user_action ua where ua.user_id = :1 ) union all select m.menu_id from indy_menu m where menu_state = '01' and m.action_normal = 'T' and m.action_authorized = 'F' and m.action_id is not null ) connect by menu_id = prior menu_parent_id ) and menu_kind in ('MenuFolder', 'MenuItem') and menu_parent_id=:2 and menu_state = :3 order by menu_index |
byuacw6h7dqkn | INSERT INTO T_YPJC_DISTTRANSFORMER
(id,
loss_id,
dist_trans_id,
dist_trans_res_id,
disttransformername,
location,
measuremode,
pub_priv_flag,
ratedcapacity,
noloadcurrent,
impedancevoltage,
ratedshortcircuitloss,
noloadloss,
suppactivequantity,
suppactivequantityafter,
suppreactivequantity,
suppreactivequantityafter)
VALUES
(sys_guid(), :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16) |
c5tmjxj6rtck4 | SELECT mis_t.tg_id id,
(SELECT mis_area.tg_cap
FROM v_mis_tg@ypjc mis_area
WHERE mis_area.tg_id = mis_t.tg_id) capacity,
(SELECT mis_area.tg_name
FROM v_mis_tg@ypjc mis_area
WHERE mis_area.tg_id = mis_t.tg_id) name, (SELECT mis_area.org_no
FROM v_mis_tg@ypjc mis_area
WHERE mis_area.tg_id = mis_t.tg_id) org_no
FROM mis_pms_tran_map@ypjc m, v_mis_g_tran@ypjc mis_t
WHERE m.equip_id = mis_t.equip_id
AND m.org_no LIKE :1
AND mis_t.org_no LIKE :2
AND m.distran_object_id IN (
:3) |
cfrwbnuu2xtam | select side_b from ol$_association_constraints where association_type = :1 and side_a = :2 |
cv0rtthxrhdxy | SELECT O.S_04 || :B2 FROM OL$_ASSOCIATIONS A, OL$_OBJECTS O WHERE A.A = O.OBJ_ID AND A.B = :B1 AND ROWNUM = 1 |
d3gsxy5k0u8hw | select * from v$_ST_Asset where ( orgId = :1 ) and OBJ_ID in (select /*+ INDEX ( ol$_associations NK_OL$_REFS_URI_A ) */ ol$_associations.b obj_id from ol$_associations where ol$_associations.ast_uri = :2 and ol$_associations.a = :3 ) |
d7qa0bq22h0p3 | SELECT A FROM OL$_ASSOCIATIONS WHERE B = :B1 |
d9s3b9vwvm5t2 | declare
begin
PRO_YWTJ_ALL;
end; |
dnctudjagb520 | select * from v$_ST_AssetModel where ( orgId = :1 ) and OBJ_ID in (select /*+ INDEX ( ol$_associations NK_OL$_REFS_URI_A ) */ ol$_associations.b obj_id from ol$_associations where ol$_associations.ast_uri = :2 and ol$_associations.a = :3 ) |
f5yun5dynkskv |
select s.synonym_name as object_name, o.object_type
from all_synonyms s, sys.all_objects o
where s.owner in ('PUBLIC', :schema)
and o.owner = s.table_owner
and o.object_name = s.table_name
and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
|
f8uvk4ymbh19z | SELECT NAME, TYPE, ACTION_URL, actionname, activity_name, ticket_no, filler_id, filler, leader, leader_id, str_start_date, str_end_date, issuer, issuer_id, issue_date, permit_permiter_id, permit_permiter, week_plan_id FROM v_all_ticket1_query T WHERE T.WEEK_PLAN_ID =:1 |
fc42s7rxq7chg | SELECT CLS_URI FROM OL$_CLASSES WHERE CLS_ID = :B1 |
fkc00x536y5kw |
select /*+rule*/ p.OBJ_ID as id,
p.NAME as psrName,
OL$_OBJECT_UTIL.GETPARENTID(P.PATHNAME) as parentID,
p.cls_uri as psrGroupID,
c.cls_disp_name AS psrGroupName,
to_number(getViewAttribute(c.cls_view, p.obj_id, 'lpsequence')) as lpsequence,
'' as attemperNumber,
c.cls_view as clsView,
p.VOLTAGELEVEL AS VOLTAGELEVEL
from v$_st_powersystemresource p, ol$_classes c, v$_st_powersystemresource power
where p.cls_uri = c.cls_uri
AND c.cls_uri IN
('OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_EquipmentContainer/ST_Line/ST_Feeder', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_Equipment/ST_ConductingEquipment/ST_Switch/ST_Fuse/DropoutFuse', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_EquipmentContainer/ST_TransmisPolePosition', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_Equipment/ST_DisTransformer', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_EquipmentContainer/ST_HolePosition', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_Equipment/ST_ConductingEquipment/ST_Switch/ST_Disconnector', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_Equipment/ST_ConductingEquipment/ST_Switch/ST_ProtectedSwitch/ST_LoadBreakSwitch', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_Equipment/ST_ConductingEquipment/ST_Switch/ST_Fuse', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_EquipmentCont
ainer/ST_Station/ST_CableBox', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_EquipmentContainer/ST_CompositeSwitch/ST_RMU', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_Equipment/ST_ConductingEquipment/ST_Switch/ST_ProtectedSwitch/ST_Breaker', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_EquipmentContainer/ST_Station/ST_BoxStation', 'OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource/ST_EquipmentContainer/ST_Station/ST_DisStation') and p.PATHNAME LIKE power.PATHNAME||'%'
AND p.RESOURCESTATUS <> 'I'
and power.OBJ_ID = :1
and power.orgId = :2
and p.orgId = :3
ORDER BY lpsequence |
fzu969xyv90pv | SELECT * FROM ( Select (Select org_name From sgpm.o_org Where org_no = substr(orgid, 1, 5)) "Êе¥Î»",
(Select org_name From sgpm.o_org Where org_no = orgid) "ÏØµ¥Î»",
(Select a.Cls_Disp_Name From Ol$_Classes a Where Cls_Uri = s.Cls_Uri) "É豸ÀàÐÍ",
s.NAME,
ol$_tools.getallpathnamebypathid(pathname) É豸·¾¶,
'' "É豸ÐͺÅΪ¿Õ"
From V$_St_Asset s
Where s.ASSETSSTATUS = 'S'
and s.SBXH is null
and exists (select 1
from ol$_attr_defs t
where t.cls_uri = s.CLS_URI
and attr_name = 'SBXH'
and t.cat_id is not null)
and s.ORGID = :1 ) WHERE rownum <= :2 |
g0mmxhhfz1q9g | select * from v$_LowArea where ( orgId = :1 and ResourceStatus = :2 ) and OBJ_ID in (select /*+ INDEX ( ol$_associations NK_OL$_REFS_URI_A ) */ ol$_associations.b obj_id from ol$_associations where ol$_associations.ast_uri = :3 and ol$_associations.a = :4 ) order by cls_uri |
g4rzpg6rj116d | BEGIN
OL$_RULE_CORE.SETSTRATTR(:1, :2);
END; |
g5cxtvzf3du35 | SELECT COUNT(1) cnt FROM( Select Obj_Id "Ïß·ID", Name "Ïß·Ãû³Æ", Getpathnamebypathid(Pathname) "Ïß·λÖÃ"
From V$_St_Feeder t
Where Orgid = :1
And t.Resourcestatus = 'E'
And t.LINEKIND<>'30'
And Not Exists
(Select 1
From Ol$_Associations a
Where a.a = t.Obj_Id
And a.Ast_Uri = 'OLASSOCIATIONTYPE://ST_IdentifiedObject_ST_IdentifiedObject?A="OLCLASS://Entity/ST_IdentifiedObject"&B="OLCLASS://Entity/ST_IdentifiedObject"'
And Exists (Select 1
From V$_St_Linesection
Where Obj_Id = a.b
And Resourcestatus = 'E'
And Orgid = :2))) |
ggsus9qmhfqws |
SELECT COUNT(1) cnt FROM( With Temp_St_Transmispoleposition As (
Select v.OBJ_ID
From Olive.V$_St_Transmispoleposition v
Where v.Resourcestatus = 'E'
And v.Orgid =:1
And Exists (Select 1
From Olive.Ol$_Associations Aa
Where Aa.b in (Select a.b
From Olive.Ol$_Associations a,
Olive.V$_St_Pole p
Where a.a = v.Obj_Id
And a.b = p.Obj_Id
And a.ast_uri='OLASSOCIATIONTYPE://ST_PowerSystemResource_ST_Asset?A="OLCLASS://Entity/ST_IdentifiedObject/ST_PowerSystemResource"&B="OLCLASS://Entity/ST_IdentifiedObject/ST_Asset"')
And Aa.a <> v.Obj_Id)
)
Select (Select o.Org_Name From Sgpm.o_Org o Where o.Org_No = f.Orgid) "ÏØµ¥Î»",
f.Obj_Id,
f.Name "Ïß·Ãû³Æ",
Olive.Pkg_Imp_Equi_Common.Getpathnamebypathid(f.Pathname) "Ïß··¾¶",
f.Tconnectid,
(Select Olive.Pkg_Imp_Equi_Common.Getpathnamebypathid(v.Pathname)
From Olive.V$_St_Transmispoleposition v
Where v.Obj_Id = f.Tconnectid
And v.RESOURCESTATUS='E'
) "T½Ó¸Ë·¾¶"
From Olive.V$_St_Feeder f
Where f.Resourcestatus = 'E'
And f.Tconnectname Is Not Null
And Length(f.Pathname) > 260
And f.Orgid = :2
and exists (select 1 f
rom Olive.V$_St_Transmispoleposition where obj_id = f.Tconnectid)
And Not Exists (Select 1
From Temp_St_Transmispoleposition t
Where t.Obj_Id = f.Tconnectid)) |
gk7v3zx64y3ma | INSERT INTO t_ypjc_lowlinesegment
(id,
loss_id,
low_area_id,
low_area_original_id,
low_area_name,
low_line_id,
low_line_original_id,
low_line_name,
low_line_segment_id,
low_line_segment_original_id,
low_line_segment_name,
location,
wire_length,
wire_type_code,
wire_type_name,
wire_unit_resistance,
wire_unit_reactance)
VALUES
(sys_guid(), :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16) |
gkw6wc3pm09j6 | SELECT USER_NAME FROM AMBER.INDY_USER_ACTION U WHERE U.ACTION_NAME=:1 |
grwydz59pu6mc | select text from view$ where rowid=:1 |