CREATE TABLE table_1886270_1 (hr_no VARCHAR2, hr_name VARCHAR2)

When river ness is the hr name what is the hr number?
SELECT hr_no FROM table_1886270_1 WHERE hr_name = "River Ness"
SELECT "hr_no" FROM "table_1886270_1" WHERE "River Ness" = "hr_name"