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?
- 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.