Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    2

    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?

    Thanks, Clare

  2. #2
    Join Date
    Oct 2003
    Location
    UK
    Posts
    7
    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.

  3. #3
    Join Date
    Oct 2003
    Posts
    2
    Thanks - tried single quotes but for some stupid reason didn't try it with double quotes.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •