Originally posted by Avi Abrami:
Adeel,
The correct syntax is "<sequence_name>.nextval" -- where <sequence_name> is the name of the sequence you require.
Perhaps you (and Santosh) should check the "SQL Reference" manual. It is available from here:
http://tahiti.oracle.com
Avi, did you feel I wrote the real syntax. Actually not, my intend is to give an idea not the real syntax.
Its good if you are so kind to give the real syntax, "Spoonfeeding". Anyhow, its your style and that was mine
.
Thanks for the reference.
[ March 30, 2005: Message edited by: Adeel Ansari ]