Toad World® Forums

Using sequences in Toad


I am trying to insert new data into tables using the sequence the table uses for new IDs. when i enter the sequence into my SQL, i get a table/view does not exist message. I can use the sequence in other applications. i was wondering if toad can use/view sequences? i am using version 3.5.

Post your SQL. You may need to fully qualify your table name (database.schema.tableName) specially if your connection is not defaulting to the database that your table is in. Hard to know if that is the problem without seeing your SQL.

I agree. Post your SQL and let’s have a look. Include the database and version you are using.