2009년 8월 15일 토요일

Oracle sequence 생성시 order 옵션에 대해

Oracle sequence 생성시 Order 옵션에 대한 설명(트윗/페이스북 하다 보니 블로그가 너무 띄엄띄엄해지네요...)

ORDER.

Forces sequence numbers to be output in order of request.

In cases where they are used for timestamping, this may be required. In most cases, the sequences numbers will be in order anyway, so ORDER will not be required.

ORDER is necessary only to guarantee ordered generation if you are using Oracle with the Oracle Real Application Clusters option in parallel mode. If you are using exclusive mode, Oracle sequences numbers are always generated in order.


댓글 없음:

댓글 쓰기

가장 많이 본 글