By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table test as
SELECT * FROM (
SELECT '01.00 01.12' AS c_ FROM DUAL
UNION ALL
SELECT '01.00^01.13' FROM DUAL
UNION ALL
SELECT '01.00 01.15' FROM DUAL );
3 rows affected
select c_ from test order by 1 ;
| C_ |
|---|
| 01.00 01.12 |
| 01.00 01.15 |
| 01.00^01.13 |
select c_, standard_hash( c_ , 'MD5' )
from test
order by 2 ;
| C_ | STANDARD_HASH(C_,'MD5') |
|---|---|
| 01.00 01.12 | 0x335DCA42DEDECEDC19BA65065A7777EC |
| 01.00^01.13 | 0x4E1661DF191EB006274BE5552A998280 |
| 01.00 01.15 | 0xC1197D14549263A867FD9850F42B68B1 |
select c_, standard_hash( c_ , 'SHA256' )
from test
order by 2 ;
| C_ | STANDARD_HASH(C_,'SHA256') |
|---|---|
| 01.00 01.12 | 0xA367F00F2ECD669AAF2241D22DB5A794A862F8F375100E02460221A3B4FC6E99 |
| 01.00 01.15 | 0xA8A2796734C97616E35630D3ED60CDDBEAFC7846B6FDECC1D503FE02066DF453 |
| 01.00^01.13 | 0xB913BC75E6D9541471F07C01CA43AC7238FFF28CFAC6BF6750F41863ED129386 |