What do you get when running the query

SELECT a.serial_num user_serial FROM device a WHERE (LOWER(a.name) = 'test' OR a.mgmt_ip_addr = 'test')

in SQLPlus (or any other tool)?