I just finished creating MANY tables that have column names starting with a number. I didn’t realize it was an issue until I started trying to select data from my tables using the column names in the where clause. Inserts work. Selects without where work.
Is there any way to keep the column names or will I have to change them all to be able to limit a select?
SQL> select * from tbl5bis where 5bis_id = 1;
select * from tbl5bis where 5bis_id = 1
ERROR at line 1:
ORA-00920: invalid relational operator
The way I named the columns makes the most sense for the data they are holding . . . I would like to keep the column names if possible but obviously I have to be able to use the where clause.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!