老师问小明:「小明,你知不知道阿房宫是谁烧的。」
小明:「老师,……不是我烧的。」


Oracle:
alter session set current_schema = XXXX_MDB;
select * from CoreDeletedObjects DelObj
join CoreJPOSchema jpo on jpo.class_id = TO_NUMBER(SUBSTR(CAST(RAWTOHEX(DelObj.oid) AS nvarchar2(32)),1,8), ‘XXXXXXXX’)
join XXXX_CDB_SCHEMA.IJNamedObject nm on nm.oid= jpo.BOClsid
left join CoreUserLogin UsrLog on delObj.UIDDeletedBy = usrLog.oid;

SQL:
select DelObj.*, nm.UserName,UsrLog.UserLogin
from CoreDeletedObjects DelObj
join CoreJPOSchema jpo on jpo.class_id = dbo.COREHexaStringToInt(LEFT(CAST( delObj.Oid AS VarChar(50)),8))
join XXXX_CDB_SCHEMA.dbo.IJNamedObject nm on nm.oid= jpo.BOClsid
left join CoreUserLogin UsrLog on DelObj.UIDDeletedBy = UsrLog.oid
Replace the XXXX_CDB_SCHEMA with name of catalog schema name associated with model database.

您需要登录 或注册 后才可以发表评论。