Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SQL syntax help

SQL syntax help

From: Ashwath Kakhandiki <ashwath_at_bluedog.com>
Date: Fri, 17 Mar 2000 14:57:05 -0800
Message-ID: <sd5dv3dvfja29@corp.supernews.com>


Hi everyone,

I have two SQL query statements like this:

SELECT ID FROM ID_TABLE set variable id = ID in Java code

UPDATE ID_TABLE SET ID= "+ (id+1) + " WHERE ID=" + (id);

Is there a safe way to do this so that it will succeed

for all callers? It is supposed to return a unique,

increasing number every time it's called. Received on Fri Mar 17 2000 - 16:57:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US