Oracle 21C, new feature blockchain tables.

I’ve spoken in the past about the utility of blockchain, to create a table that can not be altered. Oracle 21C is not available in OCI.

The syntax to create a blockchain table is quite simple.

create blockchain table test (x number)
NO DROP UNTIL 30 DAYS IDLE
NO DELETE LOCKED
HASHING USING "SHA2_512" VERSION "v1";

The addition of the blockchain keyword, the options no drop until <>, no delete, locked, and specifying the hashing algorithm and version.

This entry was posted in infosec by rlockard. Bookmark the permalink.

About rlockard

Robert Lockard is a professional Oracle Designer, Developer and DBA working in the world of financial intelligence. In 1987 his boss called him into his office and told him that he is now their Oracle Wizard then handed him a stack of Oracle tapes and told him to load it on the VAX. Sense then, Robert has worked exclusively as an Oracle database designer, developer and Database Administrator. Robert enjoys flying vintage aircraft, racing sailboats, photography, and technical diving. Robert owns and fly’s the “Spirit of Baltimore Hon” a restored 1948 Ryan Navion and lives in Glen Burnie Maryland on Marley Creek

Welcome to oraclewizard