I created a table xx with columns a,b in swx schema.
I logged in swx schema and i issued a command
select * from xx where a is null;
I got a error saying column not found.
when i tried with
select * from xx where "a" is null.Its working.I have lot of tables in this schema and all these tables are created with one sql script.I used to run this sql script on this schema to create these tables.
I created the schema swx with def tablespace users and temp tablespace temp quata unlimited on users.
Granted dba to swx.
My question is when i try the same sql statement with some other table its working and in some table its not working.
Check the syntax of the create table statement. You can set a column name to lower case by using quotation marks, but you don't really want to do that - let Oracle manage the case (it all goes upper case in the dictionary, but you can use lower case to reference the column in a query). My guess is the create table statements are not consistent - someone is using quotation marks.