How can I separate the undef data and NULL data?

Hmmmm.... This question doesn't make sense to me, for 'undef' is a concept in the Perl domain, and 'NULL' is a concept in the SQL domain. This means that in Perl you don't have NULL, and in SQL, you don't have undef. From DBI:

NULL values are represented by undefined values in Perl