Re: Creating a table

don't use the doubled-quotes -- these tell oracle to use the quoted string literally as an object (column) name, and not check for standard naming conventions

if you check the data dictionary (or do a describe or look at the column listing in TOAD) you will see the columns are created with non-standard lower-case names

when you issue SELECT refer ... you've not told Oracle to treat the column name specially, so it is looking for a column with named REFER (upper case, standard naming convention)

in your case, you SQL will always need to quote the column names, i.e. SELECT "refer" ... -- best solution is to recreate your table without using double-quoted column names

• mcs

"lfb" <lfinet_baron_at_hotmail.com> wrote in message news:bpvt1k$v3m$1_at_s1.read.news.oleane.net...
| Hi,
|
| I'd like to create a simple table through this script :
|
| create table MC_ETUDES (
| "refer" NUMBER(6) not null,
| "libelle" VARCHAR2(128) not null,
| constraint PK_MC_ETUDES primary key ("refer")
| )
|
| I use Toad and see my table "properly" created.
| I lunch a SELECT * FROM MC_ETUDES and the colums are ok (refer and
libelle).
| But when I try SELECT refer FROM MC_ETUDES, i receive the message "invalid
| column"... (whatever the column I ask).
| Besides, in Toad, when I ask for the script to create my table MC_ETUDES,
I
| get the error "Invalid Variant Operation".
|
| What can I do ? (I'm new with Oracle...).
| Thanks,
| Laurent.
|
|
Received on Tue Nov 25 2003 - 09:50:59 CST