November 12th, 2003, 08:58 PM
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
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)
November 12th, 2003, 09:28 PM
what's a UID? I am an Oracle DBA, never heard of it (I do lead a sheltered life though)
November 12th, 2003, 09:52 PM
a unique identifier i'm assuming
November 12th, 2003, 10:53 PM
Well closest I can figure is that he's talking about the Oracle Sequence object. Which is used to provide unique id's.
not sure what is meant by borrowed uid though
create sequence tempseq;
insert into tab1 (id, col1) values (tmpseq.nextval,'some data');
November 12th, 2003, 11:02 PM
i'll let him know and see if that is what he is talking about. thanks for the post.
November 13th, 2003, 08:21 AM
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;