Redian新闻
>
Generate Unique ID for an existing Oracle Table
avatar
l*e
2
http://www.youtube.com/watch?v=ezerLW5jPwI
The king's crossing was the main attraction
Dominoes falling in a chain reaction
A scraping subject ruled by fear
Told me whiskey works better than beer
The judge is on vinyl, decisions are final
And nobody gets a reprieve
And every wave is tidal - if you hang around
You're going to get wet
I can't prepare for death any more than I already have
All you can do now is watch the shells
The game looks easy, that's why it sells
Frustrated fireworks inside yo
avatar
F*n
3
I have a Oracle table with a unique column and a lot of existing data. I
want to insert new records. What is the best way to generate unique
identifiers for this column? sys_guid? I cannot use sequence and the unique
column has not used any auto-increment mechanism.
avatar
n*y
4
i k.. although it s old...
avatar
wh
5
哇这支歌很好听。教主有没有?
avatar
B*g
6
why "I cannot use sequence"?

unique

【在 F****n 的大作中提到】
: I have a Oracle table with a unique column and a lot of existing data. I
: want to insert new records. What is the best way to generate unique
: identifiers for this column? sys_guid? I cannot use sequence and the unique
: column has not used any auto-increment mechanism.

avatar
J*G
7
童安格所有很红的歌里,我就是饭不起来这首,虽然不难听。。。
avatar
F*n
8
Because it was not created by me and there are already a lot of records in
it with all kinds of numbers in that column.

【在 B*****g 的大作中提到】
: why "I cannot use sequence"?
:
: unique

avatar
s*l
9
点解?

【在 J*G 的大作中提到】
: 童安格所有很红的歌里,我就是饭不起来这首,虽然不难听。。。
avatar
B*g
10
instead of update that column to sys_guid, update that column to a sequence.
I know we all hate SQL:
update table SET column = seq.nextval

【在 F****n 的大作中提到】
: Because it was not created by me and there are already a lot of records in
: it with all kinds of numbers in that column.

avatar
J*G
11
没啥解,就是很好听的一首歌,俺这种各色人没听出来有啥好的。。。

【在 s******l 的大作中提到】
: 点解?
avatar
F*n
12
How can I make sure that seq.nextval will not hit one of the existing
numbers in that column? Currently my workaround is to start from the max. Is
there a better practice?

sequence.

【在 B*****g 的大作中提到】
: instead of update that column to sys_guid, update that column to a sequence.
: I know we all hate SQL:
: update table SET column = seq.nextval

avatar
T*r
13
一开始我也不喜欢这首。但现在听起来觉得从配乐到写词都如泣如诉,是一首非伤透心
的人作/唱不出来的歌。每个音符都象含在泪里^^
avatar
B*g
14
不是特大的table一般都这样做

Is

【在 F****n 的大作中提到】
: How can I make sure that seq.nextval will not hit one of the existing
: numbers in that column? Currently my workaround is to start from the max. Is
: there a better practice?
:
: sequence.

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。