question on database table

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.

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???

Thanking you in advance......

Regards
Wilson Luong
Software Engineer Received on Thu Aug 01 1996 - 00:00:00 CEST