Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 558

An object that can generate unique integers.

5
votes
You can use a CONNECT BY query to generate an arbitrary sequence: SQL> variable v_step NUMBER SQL> variable v_maxnumber NUMBER SQL> exec :v_step := 30; :v_maxnumber := 211; PL/SQL procedure …
answered Dec 20 '12 by Vincent Malgrat
7
votes
This is the expected behaviour of nextval as documented: Within a single SQL statement containing a reference to NEXTVAL, Oracle increments the sequence once: For each row returned by the … outer query block of a SELECT statement [...] If any of these locations contains more than one reference to NEXTVAL, then Oracle increments the sequence once and returns the same value for …
answered Oct 19 '12 by Vincent Malgrat