var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Querying Sequences - Help!
I am trying to get the Next value from a sequence using the following syntax:-
select seq_name.nextval from dual;
This works for some sequences, however when I try using it for the sequence 000WALKER an error ORA-00923 - Error in From Clause is returned.
Is this becuase of the zeros in the sequence name? Is there any way round this?
You could create the sequence with double quotes e.g. create sequence "000WALKER". You would have to use the double quotes when you select as well.
Thanks - tried single quotes but for some stupid reason didn't try it with double quotes.