Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Numbers as column names?
Message
 
 
À
22/03/2001 13:41:22
Information générale
Forum:
Oracle
Catégorie:
PL/SQL
Divers
Thread ID:
00487701
Message ID:
00487731
Vues:
8
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform