1 2 Previous Next 18 Replies Latest reply: Feb 11, 2013 6:57 AM by EdStevens Go to original post RSS
      • 15. Re: Dual table not working
        Aman....
        I believe you are missing the point here. First, you must never make any object with any reserved name , especially something like DUAL which is a very special table. Second , all what is happening in your code is that you are using a sequence in the from section of the select command which is definitely not allowed as that's the place for a table.
        ORA-02201:
        sequence not allowed here
        Cause:      An attempt was made to reference a sequence in a from-list.
        Action:      A sequence can only be referenced in a select-list
        Aman....
        • 16. Re: Dual table not working
          988014
          when select all sequence

          dual table is there in the sequence list

          select * from all_sequences

          please check with the links

          [blessingmch.org/select_seq.png] [http://blessingmch.org/cannotdrop.png]
          • 17. Re: Dual table not working
            sql_coder
            Aman.... wrote:
            First, you must never make any object with any reserved name , especially something like DUAL which is a very special table.
            dual is a reserved word ? I cannot find it, even I agree it is a special table....http://docs.oracle.com/cd/E14072_01/appdev.112/e10830/appb.htm

            Ikrischer
            • 18. Re: Dual table not working
              EdStevens
              985011 wrote:
              when select all sequence

              dual table is there in the sequence list

              select * from all_sequences
              No, the dual table is most definately NOT listed in all_sequences. You have a sequence named DUAL. It is that sequence that is showing when you query all_sequences.
              >
              please check with the links

              [blessingmch.org/select_seq.png] [http://blessingmch.org/cannotdrop.png]
              Instead of forcing us to go look at a website that is blocked by many of our networks, please issue your queries in sqlplus so that you can copy the entire query and result and paste the text directly into your posts.
              1 2 Previous Next