oracle query
-
hi all, ID NAME 1 aaa 2 bbb 3 4 NULL From this table how to retrieve the records with name <> null or empty using oracle query? i should get the result like this :- 1 aaa 2 bbb how can i do this?
-
Select ID, NAME from [table name] where NAME IS NOT NULL AND NAME != ""
Education is not a way to escape poverty — it is a way of fighting it.
-
That error because of the following statement AND NAME != "" If space is there in the column you can check like this, Name != " "; and oracle treats the empty string ('') as null. refer here[^]
Education is not a way to escape poverty — it is a way of fighting it.
-
That error because of the following statement AND NAME != "" If space is there in the column you can check like this, Name != " "; and oracle treats the empty string ('') as null. refer here[^]
Education is not a way to escape poverty — it is a way of fighting it.