댓글이 안달아지네요..ㅎ
select col1, col2, substr(last_value(decode(col1,null, null, col1||col2) ignore nulls) over (order by rownum),-3) val from t
LAST_VALUE(NVL2(col1, col2, '') IGNORE NULLS) OVER(ORDER BY ROWNUM)