I have a stored procedure that selects a value into a variable:

SELECT Password INTO TablePword
	FROM UserControl
	WHERE UserID = LoginID;

If there is no UserID equal to LoginID what will the variable TablePword be populated with? I believe in SQL Server it would be a NULL value but I'm not sure what to check for in Oracle.

TIA,
George