惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

Google DeepMind News
Google DeepMind News
F
Fortinet All Blogs
量子位
G
Google Developers Blog
J
Java Code Geeks
N
Netflix TechBlog - Medium
博客园 - 聂微东
宝玉的分享
宝玉的分享
Cyber Security Advisories - MS-ISAC
Cyber Security Advisories - MS-ISAC
月光博客
月光博客
The Cloudflare Blog
Apple Machine Learning Research
Apple Machine Learning Research
爱范儿
爱范儿
雷峰网
雷峰网
M
MIT News - Artificial intelligence
T
Tailwind CSS Blog
V
Visual Studio Blog
阮一峰的网络日志
阮一峰的网络日志
博客园 - 三生石上(FineUI控件)
Microsoft Azure Blog
Microsoft Azure Blog
aimingoo的专栏
aimingoo的专栏
Martin Fowler
Martin Fowler
有赞技术团队
有赞技术团队
T
The Blog of Author Tim Ferriss

博客园 - Angus

多行记录栏位合并 使用ROWNUM实现分页 Null 比较 BOM Interface Item Interface PL/SQL Package WIP表结构 BOM表结构 INV表结构 OM表结构 PO表结构 AR表结构 AP表结构 GL表结构 HR表结构 APPLSYS表结构 Web页面消息框 Oracle ERP中的Flexfield Oracle ERP权限管理
ROWID and ROWNUM
Angus · 2006-08-22 · via 博客园 - Angus

ROWID:
   Before the release of Oracle8, ROWID datatype was used to store the physical address of each row of each table, as a hexadecimal number. You can use character host variables to store rowids in a readable format. When you SELECT or FETCH a rowid into a character host variable, Oracle converts the binary value to an 18-byte character string and returns it in the format BBBBBBBB.RRRR.FFFF ,where BBBBBBBB is the block in the database file, RRRR is the row in the block (the first row is 0), and FFFF is the database file. These numbers are hexadecimal. For example, the rowid  0000000E.000A.0007 points to the 11th row in the 15th block in the 7th database file.
ROWNUM:
   ROWNUM returns a number indicating the order in which a row was selected from a table.The first row selected has a ROWNUM of 1, the second row has a ROWNUM of 2, and so on. If a SELECT statement includes an ORDER BY clause, ROWNUMs are assigned to the retrieved rows before the sort is done.

Some Explain in Chinese:
ROWID: 数据库内部存放数据地址
ROWNUM:  选取的行数

ROWID是oracle数据文件管理的标识,信息放在第几块了,第几行了
ROWNUM是表的是逻辑上的第几行

ROWID相当于oracle数据库管理的主键,甚至就可以以它作为所在表的主键
ROWNUM应该是行号,并且顺序排列,根据你的select语句的执行动态生成