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.... wrote: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
First, you must never make any object with any reserved name , especially something like DUAL which is a very special table.
985011 wrote: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.
when select all sequence
dual table is there in the sequence list
select * from all_sequences
please check with the linksInstead 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.