Toad World® Forums



Why do I get the error that I am missing a parentheses when I try to include an ORDER BY when I am creating a table?


That’s hard to see without seeing the SQL that you are trying to execute, but in general, the only way you can include an ORDER BY in a create table statement, is when you say:

create table table_name as

select columns

from some_other_table

order by columns

If you are just making a create table statement on its own, ORDER BY does not apply.