[Beast-L]

Трассировка показывает
SELECT A.TABLEID,A.RECID FROM SQLDICTIONARY A WHERE (((FLAGS=:in1) AND (SHADOW=:in2)) AND (STRSIZE IN (:in3) ))
SELECT A.TABLEID,A.FIELDID,A.ARRAY,A.NAME,A.SQLNAME,A.FIELDTYPE,A.STRSIZE,A.SHADOW,A.RIGHTJUSTIFY,A.NULLABLE,A.FLAGS,A.RECID FROM SQLDICTIONARY A WHERE ((TABLEID=:in1) AND (SHADOW=:in2)) ORDER BY A.TABLEID,A.FIELDID,A.ARRAY,A.SHADOW
SELECT /*+ INDEX(A I_1518KEYIDX) FIRST_ROWS */A.VERSION,A.APPBUILD,A.KERNELBUILD,A.DESCRIPTION,A.NAME,A.CREATEDDATE,A.CREATEDTIME,A.CREATEDBY,A.RECID FROM SYSSETUPLOG A WHERE (((((SUBSTR(NLS_LOWER(VERSION),1,10)=NLS_LOWER(:in1)) AND (SUBSTR(NLS_LOWER(APPBUILD),1,30)=NLS_LOWER(:in2))) AND (SUBSTR(NLS_LOWER(KERNELBUILD),1,10)=NLS_LOWER(:in3))) AND (SUBSTR(NLS_LOWER(NAME),1,40)=NLS_LOWER(:in4))) AND (SUBSTR(NLS_LOWER(DESCRIPTION),1,50)=NLS_LOWER(:in5)))
SELECT /*+ INDEX(A I_1518KEYIDX) FIRST_ROWS */A.VERSION,A.APPBUILD,A.KERNELBUILD,A.DESCRIPTION,A.NAME,A.CREATEDDATE,A.CREATEDTIME,A.CREATEDBY,A.RECID FROM SYSSETUPLOG A WHERE (((((SUBSTR(NLS_LOWER(VERSION),1,10)=NLS_LOWER(:in1)) AND (SUBSTR(NLS_LOWER(APPBUILD),1,30)=NLS_LOWER(:in2))) AND (SUBSTR(NLS_LOWER(KERNELBUILD),1,10)=NLS_LOWER(:in3))) AND (SUBSTR(NLS_LOWER(NAME),1,40)=NLS_LOWER(:in4))) AND (SUBSTR(NLS_LOWER(DESCRIPTION),1,50)=NLS_LOWER(:in5)))
SELECT /*+ INDEX(A I_1518KEYIDX) FIRST_ROWS */A.VERSION,A.APPBUILD,A.KERNELBUILD,A.DESCRIPTION,A.NAME,A.CREATEDDATE,A.CREATEDTIME,A.CREATEDBY,A.RECID FROM SYSSETUPLOG A WHERE (((((SUBSTR(NLS_LOWER(VERSION),1,10)=NLS_LOWER(:in1)) AND (SUBSTR(NLS_LOWER(APPBUILD),1,30)=NLS_LOWER(:in2))) AND (SUBSTR(NLS_LOWER(KERNELBUILD),1,10)=NLS_LOWER(:in3))) AND (SUBSTR(NLS_LOWER(NAME),1,40)=NLS_LOWER(:in4))) AND (SUBSTR(NLS_LOWER(DESCRIPTION),1,50)=NLS_LOWER(:in5)))
DELETE FROM SYSCONFIG WHERE ((CONFIGTYPE=:in1) AND (ID=:in2))
INSERT INTO SYSCONFIG (CONFIGTYPE,ID,VALUE,MODIFIEDDATE,MODIFIEDTIME,MODIFIEDBY,CREATEDDATE,CREATEDTIME,CREATEDBY,RECID) VALUES (:in1,:in2,:in3,:in4,:in5,:in6,:in7,:in8,:in9,:in10)