Java 获取Oracle ROWID

iteye_3829

于 2012-04-18 00:03:37 发布

阅读量1k

点赞数

分类专栏： oracle 文章标签： java oracle

本文链接：https://blog.youkuaiyun.com/iteye_3829/article/details/82310273

版权

oracle 专栏收录该内容

7 篇文章

订阅专栏

本文介绍了Oracle数据库中ROWID的概念及用途。ROWID作为每行记录的唯一标识符，可以被视为虚拟列，存储着每行的ID。通过使用ROWID，可以实现对数据的快速检索与更新操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

A ROWID is an identification tag unique for each row of an Oracle Database table. The ROWID can be thought of as a virtual column, containing the ID for each row.

The oracle.sql.ROWID class is supplied as a container for ROWID SQL data type.

If you include the ROWID pseudo-column in a query, then you can retrieve the ROWIDs with the result set getString method. You can also bind a ROWID to a PreparedStatement parameter with the setString method. This enables in-place updating, as in the example that follows.

Note: Use the oracle.sql.ROWID class, only when you are

using J2SE 1.5. For JSE 6, you should use the standard

java.sql.RowId interface instead.

ResultSet rst = stmt.executeQuery("select rowid,name from friend");
...
String rowid=rst.getString(1);
...

//or

RowId rowid = rst.getRowId(1); // Get the ROWID as a String