Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Numbers as column names?
Message
 
 
To
22/03/2001 13:41:22
General information
Forum:
Oracle
Category:
PL/SQL
Miscellaneous
Thread ID:
00487701
Message ID:
00487731
Views:
9
>In SQL Server, I can use Quoted Identifiers as in the following and have a column name be a number:
>
>Create Table Test ([20000] char(10))
>
>Is there a way to do this in Oracle?

You can bet you always have to qualify that column name in quotes.

create table test ("2000" varchar2(20))
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform