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.
November 2, 2007 12:56 AM
November 7, 2007 5:36 PM