hi ,
I'm looking for a approach of doing hash and replace algorithm in oracle.
In mainframe we have a FILEAID tool which had inbuilt hashing algorithm. In Oracle there is not tool for our project
and we are expecting to build our own masking algorithm either using PL/SQL or another inbuilt function.
I had a customer table which had customer ID and customer name . I have another table
which had list of reference values in a table . I wanted to use this reference values and replace
them in the main table
main table name : - CUS_NAME
reference Table name :- REF_NAME
SELECT * FROM REF_NAME;
REF_NAME_VALUE
-----------------
TOM
TOMA
TOMB
TOMC
TOMD
TOME
SELECT * FROM CUS_NAME ( Duplicates are expected in this table)
CUS_ID CUS_NAME
------ ---------
1 JOHN
1 JOHN
2 ROGER
3 ASHLEY
4 BENT
5 CHRIS
Final Output
CUS_ID CUS_NAME
------ ---------
1 TOMD
1 TOMD
2 TOMA
3 TOMB
4 TOMC
5 TOME
can you please guide me how can this be achievable in oracle.
NOTE:- I'm new to oracle technology and my questions seems to be silly. Please guide me.