Blockchain Tables in Oracle Database 21c

Oracle 21c introduces a new feature called Blockchain Tables, which allows users to store and query data stored on a blockchain network directly in the database. This feature makes it easy to integrate blockchain data into Oracle-based applications, and enables users to leverage the security and immutability of blockchain technology while still using familiar SQL commands to access and manipulate the data.

Continue reading

Install Oracle Linux 8 (OEL8)

This article presents how to install Oracle Enterprise Linux 8.

I assume you have already downloaded Oracle Enterprise Linux 8 64 bit(about 4 G) and you know how to use VirtualBox 64 bit(100M). Create virtual machine with default settings for Oracle Linux 64 bit. You can set 4GB for future Oracle database software installation and 64G for disk. Rest of options you can keep default.

Continue reading

Oracle – generate INSERT statements for dynamic input query 2019

If you are working as developer/DBA probably you are quite often asked to migrate some rows from one database to another – usually people reference to the rows as “metadata” rows. Rows that driving your business !

If you need to prepare such rows for migrations there are a lot of methods to do it

just copy the rows using database link from one database to another
export/import the rows using tools like expdp/impdp
prepare manually scripts with INSERT statements

I would like to focus on the last method. It’s very popular to keep metadata in some files as number of INSERTs for backup/migrations/versioning etc.

Continue reading