By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE table1 AS
SELECT 1 id, 1 a1, 1 b1, 1 c1, 1 d1, 1 e1, 1 f1 FROM dual;
1 rows affected
CREATE TABLE table2 AS
SELECT 2 id, 2 a2, 2 b2, 2 c2, 2 d2, 2 e2, 2 f2 FROM dual;
1 rows affected
SELECT
standard_hash ( T.id || T.a1 || T.b1 || T.c1 || T.d1 || T.e1 || T.f1, 'SHA256' )
AS my_hash_1
FROM table1 T ;
| MY_HASH_1 |
|---|
| 0x2558A34D4D20964CA1D272AB26CCCE9511D880579593CD4C9E01AB91ED00F325 |
SELECT
standard_hash ( T.id || T.a2 || T.b2 || T.c2 || T.d2 || T.e2 || T.f2, 'SHA256' )
AS my_hash_2
FROM table2 T ;
| MY_HASH_2 |
|---|
| 0xCC2E018AA6EB9612CCD027BBDCDC9B8C8D351789F14CAE4D688A876C18938235 |
SELECT
standard_hash ( T.id || T.a1 || T.b1 || T.c1 || T.d1 || T.e1 || T.f1, 'MD5' )
AS my_hash_1
FROM table1 T ;
| MY_HASH_1 |
|---|
| 0x7FA8282AD93047A4D6FE6111C93B308A |
SELECT
standard_hash ( T.id || T.a2 || T.b2 || T.c2 || T.d2 || T.e2 || T.f2, 'MD5' )
AS my_hash_2
FROM table2 T ;
| MY_HASH_2 |
|---|
| 0x79D886010186EB60E3611CD4A5D0BCAE |