Author Topic: Oracle - Outputting Characters  (Read 982 times)

0 Members and 1 Guest are viewing this topic.

Offline mattclementsTopic starter

  • Enthusiast
  • Posts: 83
  • Gender: Male
    • View Profile
    • Freelance Webdesign
Oracle - Outputting Characters
« on: February 04, 2010, 06:38:44 AM »
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
Web Designer/PHP Developer/Server Admin