Answered Questions

  • Jun 23 2015
    07:11 AM
    9063
    21

    Replace Only Third Character with *
    • rohit

    How to replace only third character of employees name with * from employee table?

    Ankit

    • Mar 7th, 2018

    SELECT REPLACE(NAME,SUBSTR(NAME,3,1),*) FROM Friend_Birthday

    PAVAN

    • Jan 19th, 2018

    SELECT REGEXP_REPLACE(FIRSTNAME, SUBSTR(FIRSTNAME,3,1), *,1,1) FROM EMPLOYEE;