Oracle sql query using _ (underscore) in condition

 

Query 1:

SELECT * FROM FND_USER

WHERE

USER_NAME LIKE 'FC_%';

 

Output: FCCI, FC_

 

Query 2:

SELECT * FROM FND_USER

WHERE

REPLACE(USER_NAME, '_', '~') LIKE 'FC~%';

 

Output: Only FC_