Oracle - Outputting Characters

[mattclements]

Hello all,

I have some private details that need to be outputted replacing some characters with Stars. I would like to do this on the SELECT statement, rather than in PHP as this would be more secure. IE:

 

Oracle: 102030

SQL Select: XXXX30 or 30

PHP: XXXX30 or XXXX30

 

I don't mind formatting the output in PHP - just want the SELECT Command to SELECT the last 2 characters of a column.

 

Regards,

Matt