If the only requirement is that the result set contain exactly one row form the table:

SELECT *

FROM t1

WHERE ROWNUM = 1

;

If you want exactly one of the rows that meets some other condition (assuming there are rows that meet that condition), then add the other condition to the WHERE clause. For example, if you want exactly one row where val contains 'BKP':