运维联盟俱乐部

 找回密码
 立即注册
查看: 1470|回复: 0

[日常管理] dbms_rowid

[复制链接]
  • TA的每日心情
    开心
    2023-8-9 11:05
  • 发表于 2020-10-22 09:34:45 | 显示全部楼层 |阅读模式
    dbms_rowid.rowid_object(返回rowid对应的object值)
    select dbms_rowid.rowid_object('AAAM/hAAGAAAAAMAAA') from dual
        dbms_rowid.rowid_block_number(rowid)
    select distinct * from (select dbms_rowid.rowid_block_number(rowid) from b)
        dbms_rowid.rowid_relative_fno(rowid)
    select dbms_rowid.rowid_relative_fno(rowid) from b
    回复

    使用道具 举报

    您需要登录后才可以回帖 登录 | 立即注册

    本版积分规则

    运维联盟俱乐部 ( 冀ICP备19036648号 )

    GMT+8, 2024-5-17 14:43 , Processed in 0.047983 second(s), 21 queries , Gzip On.

    Powered by Discuz! X3.4

    © 2001-2023 Discuz! Team.

    快速回复 返回顶部 返回列表