Originally posted by santoshym

1) Oracle is not case sensitive so the tablename,columnname can be uppercase or lowercase but the values you store as rows are case sesitive
Actually, that should read that Oracle is case sensitive, so the tablename, columnname can be uppercase or lowercase (or mixed case) but the values you store as rows are case sensitive. You can have separate tables with the names TAB1, Tab1, tab1, etc. The default behavior of Oracle turns all table and column names to uppercase, so it seems like it is case insensitive.

Heath