Under same schema there are two tables with same name (in different cases) existing.
Hello,
Just want to share one problem that.
One of Oracle database (version 10.2.0.1.0) on Windows Server is giving me list of table names with same name but their case is different.
Means as for example one table name is AGED1 then other table is also with same name but different case like aged1.
so my queries are is it possible in Oracle? as i have observed in Oracle whenever i queried dba_Tables or user_tables shows me table name in upper case..
But in above mentioned database i have observed both tables means ( in upper case and lower case)..
Just want to share one problem that.
One of Oracle database (version 10.2.0.1.0) on Windows Server is giving me list of table names with same name but their case is different.
Means as for example one table name is AGED1 then other table is also with same name but different case like aged1.
so my queries are is it possible in Oracle? as i have observed in Oracle whenever i queried dba_Tables or user_tables shows me table name in upper case..
But in above mentioned database i have observed both tables means ( in upper case and lower case)..
0