Are there rules/constraints for naming new table?

Toad for Oracle & DevOps Toolkit
1

FYI - I just starting using Toad for Oracle version 11.5, and have limited SQL experience, so my terminology may not be the best.

Are there rules/constraints for naming new tables? If yes, where can I find them?

For example:

  • Is there a limit on the number of characters you can use in a table name?
  • Can a table name start with a numeral?
  • Can you use special characters in the the table name?

I tried to create a new table called 2010_LINES, but it was not working (it said 2010 was an invalid identifier) . When I changed it to LINES_2010 it worked fine. It’s obvious that using 2010 at the beginning was causing the problem, but I’d like to find out what the rest of the rules are.

Thanks,

Joe

2

Hi there, Joe

Can you please join our Yahoo group?
http://tech.groups.yahoo.com/group/toad/

Users and even our developers provide answers there.

For your table, Toad simply directly accesses your Oracle database, so what’s true for Oracle is true for Toad and I think if you want to begin a table name with a number, you must put it in quotes.