Oracle in querying data

Problem Description:

Query all data, query result: 146360

Select Count (1 from

In query get partial data, query result: 73080

Select Count(1) fromBANK_CDE TwhereT.belongcode2inch('ABC','BCom','BOC','CCB','CEB','CGB','CIB','CITIC','CMBC','ICBC','PAB','POST','SPDB');

Not in query data with a result of 0

Select Count(1) fromBANK_CDE TwhereT.belongcode2 notinch('ABC','BCom','BOC','CCB','CEB','CGB','CIB','CITIC','CMBC','ICBC','PAB','POST','SPDB');

Reason:

This thought that in and not are complementary to the query results, and another case is null

Select Count (1fromwhereisnull;

Oracle in querying data