Re: question on database table

Venkateswara R Polisetti wrote:
>
> Wilson Luong <luong.wilson.wh_at_bhp.com.au> wrote:
>
> >Hi,
 

> >I just want to verify a question i had with you oracle experts out there. Is Oracle case sensitive in relation to table names and field names within the table.
 

> >eg. If i created a table (myTable) with field (myField) in it, will Oracle save the table name as myTable or will it save it as MYTABLE. Likewise will the field
> >be saved as myField or will it be saved as MYFIELD. If it is not case sensitive, then i would need to name the table to MY_TABLE and the field name to MY_FIELD in
> >order to have a readable table name and field name.
>
> Oracle table and column names, by default, are case in-sensitive. It
> does not matter what ever the case may be when you create a table. But
> Oracle provides a way to make your table and column names to have
> embeded spaces and case sensitive. While creating your table put the
> table, column names in double quotes ("). Then Oracle will store the
> quoted elements as is into the data dictionary, in which case when you
> reference those objects you have to put them in quotes exactly as you
> have defined them.
>
> >Also, just another simple question. What is the maximum number of characters i can have for a table and field name. I've been told its 32. Is that correct???
>
> No, It is only 30 characters, not 32.
>
> >Thanking you in advance......
 

> >Regards
> >Wilson Luong
> >Software Engineer
>
> Venkateswara Rao
>
> /-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-\
> | Venkateswara R.Polisetti Email: vrao_at_sctcorp.com |
> | SCT Utility Systems, Inc. Phone(O): (803) 935-8160 |
> | 9 Science Court (R): (800) 736-1609 |
> | Columbia, SC 29203-9344 |
> \-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-/

Additionally,

Many third party products

  SAS, PowerBuilder etc

will when creating tables embed the table_names and column_names in quotes "".

This is a real pain, but allows for alot of freedom, if your naming conventions can stand it.

-- 
______________________________________________________________________
Michael J. Hillanbrand II                                Dulcian, Inc.
                   Oracle Data Base Administration
Voice: 215-773-7307                               Fax:    610-277-2966
mjhii_at_pop.erols.com                         mjh_at_salts.icpphil.navy.mil
                Delaware Valley Oracle Users Group, Inc.
Contact me for Newsletter ads, articles, book reviews & Website Info.