none
Oracle数据库操作 RRS feed

  • 问题

  • 客户DBA在数据库日志中发现如下语句:

    SELECT
    C1, C2, C3 FROM (SELECT ACC.COLUMN_NAME C1, ACC.CONSTRAINT_NAME C2,
    AC.CONSTRAINT_TYPE C3 FROM ALL_CONS_COLUMNS ACC, ALL_CONSTRAINTS AC WHERE
    (AC.CONSTRAINT_TYPE = 'P' OR AC.CONSTRAINT_TYPE = 'U') AND AC.TABLE_NAME = :B2
    AND AC.OWNER = :B1 AND AC.TABLE_NAME = ACC.TABLE_NAME AND AC.OWNER = ACC.OWNER
    AND AC.CONSTRAINT_NAME = ACC.CONSTRAINT_NAME UNION SELECT AIC.COLUMN_NAME C1,
    AI.INDEX_NAME C2, 'U' C3 FROM ALL_INDEXES AI, ALL_IND_COLUMNS AIC WHERE
    AI.UNIQUENESS = 'UNIQUE' AND AI.TABLE_NAME = :B2 AND AI.TABLE_OWNER= :B1 AND
    AI.TABLE_NAME = AIC.TABLE_NAME AND AI.TABLE_OWNER = AIC.TABLE_OWNER AND
    AI.INDEX_NAME = AIC.INDEX_NAME AND AI.OWNER = AIC.INDEX_OWNER) ORDER BY 3, 2,
    1

    但是程序中并未涉及到此功能,网上有个帖子说是:.net的oracleDataAdapter的一些组件,例如,command builder自动调用的.请问一下这个真的会这样吗?

    2014年8月28日 2:50

全部回复