Java 获取Oracle ROWID

最新推荐文章于 2024-11-02 00:21:03 发布

原创最新推荐文章于 2024-11-02 00:21:03 发布 · 1.1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java #oracle

oracle 专栏收录该内容

7 篇文章

订阅专栏

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

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