oracle rowid 问题# Database - 数据库
B*g
1 楼
一个procedure， 是用第一种方法好，还是第二种(id 是table的pk，unique index？
为什么？ 谢谢
1.
select rowid，....
into lnRowi1d, ......
from tab1
something between
update tab1
set .....
where rowid = lnRowi1d
2.
select id，....
into lnId, ......
from tab1
something between
update tab1
set .....
where id = lnId
为什么？ 谢谢
1.
select rowid，....
into lnRowi1d, ......
from tab1
something between
update tab1
set .....
where rowid = lnRowi1d
2.
select id，....
into lnId, ......
from tab1
something between
update tab1
set .....
where id = lnId
