Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

mask data in sql

SUBSTR (empno, 1, 3)    -- first 3 characters|| 'XXXX'|| SUBSTR (empno, -3)   -- last 3 characters
Source by community.oracle.com #
 
PREVIOUS NEXT
Tagged: #mask #data #sql
ADD COMMENT
Topic
Name
1+5 =