To avoid errors and extra errors handling in script or PL/SQL code Oracle extended CREATE/DROP DDL with IF[NOT]EXISTS clause
CREATE TABLE IF NOT EXISTS test_tbl
DROP TABLE IF EXISTS test_tbl;
it’s real game changer for coding. Life is more simple now.
This article describes nice new feature SQL_MACRO that allows to simplify coding in PL/SQL for table expressions.
This article shows new columns HIGH_VALUE_CLOB type CLOB, HIGH_VALUE_JSON type JSON in dictionary views DBA|ALL|USER_TAB_PARTITIONS
This article presents how to install Oracle 23C developer Release on Oracle Enterprise Linux 8 (OEL8) using RPM.
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.
This article presents how to install and configure Apex 21.2 with standalone ORDS 21.2
This article presents how to install Oracle 21C on Oracle Enterprise Linux 8 (OEL8) in silent mode.
This article presents how to install Oracle 21C on Oracle Enterprise Linux 8 (OEL8) using rpm
This article show simple coding standard that I use for coding. Simple rules clean code.
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.