SQL & PL/SQL

Hi,

1.
How do I check for empty string and null?

in_value IN VARCHAR2

2. Also how do I assign same value to multiple variables?

var_one NUMBER := 0;
var_two NUMBER := 0;

var_one := var_two := 0; --- Gives an error

Thanks