#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Posts
    3
    Rep Power
    0

    Borrowed UID sequence?


    My son came home today from school (Oracle Academy) and asked me about writing a specific sequence for borrowing a UID. I have never heard of this. I am not a DBA but I do have some experience with SQL. This is the specific question he asked me:

    how do I write a borrowed UID in sql and is there a specific sequence to write a borrowed
    UID?

    Has anyone heard of this and if so where can I find reference material on it?

    If this sounds like a silly question, it is. Thats why i'm asking it... (hehe)
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Apr 2002
    Posts
    693
    Rep Power
    26
    what's a UID? I am an Oracle DBA, never heard of it (I do lead a sheltered life though)
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Posts
    3
    Rep Power
    0
    a unique identifier i'm assuming
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Apr 2002
    Posts
    693
    Rep Power
    26
    Well closest I can figure is that he's talking about the Oracle Sequence object. Which is used to provide unique id's.

    ie.
    PHP Code:
    create sequence tempseq;

    insert into tab1 (idcol1values (tmpseq.nextval,'some data'); 
    not sure what is meant by borrowed uid though
  8. #5
  9. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Posts
    3
    Rep Power
    0
    i'll let him know and see if that is what he is talking about. thanks for the post.

    D
  10. #6
  11. No Profile Picture
    Senior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Location
    Canada
    Posts
    308
    Rep Power
    11
    I dont know what is the actual meaning of UID for you, but in Oracle terminology UID is a unique user id. whenever user connect to sqlplus oracle assigns it to a unique id, no matter how many sessions user have opened, all sessions are use this specific UID. For a DBA point of view this UID can be used to kill the all session of any specific user.
    You can find this UID by typing the follwoing query in SQL*Plus:

    SELECT uid, user FROM dual;

    UID USER
    --------- -------------------
    7865 SHAFIQM


    Regards,

IMN logo majestic logo threadwatch logo seochat tools logo