Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2005
    Posts
    13

    Unanswered: sequenced fields

    Hi everybody,

    When defining a sequenced field for a table, what is the best scale to use?
    It seems obvious that it somehow depends on table-scalability, but are there any issues that I should pay attention to?

  2. #2
    Join Date
    Sep 2004
    Location
    London, UK
    Posts
    565
    I'm taking a guess that a "sequenced field" is a column populated using a sequence.

    I'm afraid you've lost me with "scale" and "table-scalability" though. Do you mean how large to make the number, as in precision and scale?
    Last edited by WilliamR; 03-16-06 at 08:45.

  3. #3
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Well, today I've heard of "sequenced field" for the first time. Google found some references, and it made me think that this is a) Oracle Applications term, b) doesn't have anything to do with Oracle. I'm unable to help in any of these areas

  4. #4
    Join Date
    Sep 2004
    Posts
    60

    Lightbulb

    Using sequence for populating column is good thing as you can always maintain referential integrity through other fields of column. Few things for using sequence usage are:
    1. You should make sure that various sequences for various tables should not contradict each other. (Specially when you join/compare).
    2. Application logic should be intelligent enough not to use same value (should not select/use curr.val or next.Val)of sequence in different sessions at given point of time.
    3. Sequence always populate NUMBER type field. Its length should be long enough to serve your application/logic for desired time.

    I would say first point will be least important as logic shall never reached at any point when comparison of sequenced fields make any error/bug generation in application.

    Other then these I heard their may be issues in sequence during Export/Import. But havn't got any information for this.

    Any one has any other points !!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •