Autonomous – Page 2 – Radu Pârvu

Oracle Database: Constraints Tutorial

This article compiles various queries and code blocks used to manage disabled constraints in a database schema. It includes SQL statements to identify and enable these constraints. The content will be updated regularly with new insights, and it lists the tested database versions, starting with Oracle Database 23ai.

September 26, 2024

Ensuring PL/SQL Code Integrity with Checksums

The content explains how to implement a checksum for PL/SQL procedures to detect unauthorized modifications. It details steps for generating a checksum using Oracle’s DBMS_CRYPTO, storing it for future verification, and comparing it against current values. This approach helps ensure the integrity of PL/SQL procedures over time.

September 24, 2024

SQLcl: Customizing on a Mac

In this post I will summarize the steps I’ve taken to customize SQLcl on my Mac working environment. We assume that the reader is familiar with the procedures outline din my previous post on SQLcl on setting up SQLcl on Mac environment. Terminal customization First I start with changing the terminal a bit in order…

May 4, 2023

SQLcl: Setup on a Mac

Simple and straightforward steps about how to setup Oracle’s new SQL command line tool on a macOS X environment. Download Application and Environment Setup Attempt to start the application: Setup Java Download Java from the Oracle site. As I am on a mac wit M processor (ARM) , I cannot install jre-8u371-macosx-x64.dmg, so I cannot…

May 4, 2023

Column Level Collation Example

The feature was first introduced in 12.2 . It basically determines how the string comparison takes place. In order to use the feature, extended data types should be enabled.

October 24, 2021

How to monitor SQL with Oracle SQL Developer

The easiest way to monitor the SQL’s currently executing

June 28, 2021

I am speaking at SPOUG20

Autonomous Database is the best Cloud Database but many Clients wonder about its security! This talk will address those concerns! Oracle Autonomous Database might be the answer to the most database security challenges. In this presentation, I will walk through the way the Oracle’s Autonomous database products protect against the security threats. By design. We…

October 14, 2020

Is Oracle Autonomous Database the answer to the many database security issues? (II)

In the previous article, I discussed the main differentiating capabilities of the Autonomous, what makes it special on the market. In this post, I will discuss how are those capabilities implemented.

May 25, 2020

Is Oracle Autonomous Database the answer to the many database security issues? (I)

There is no surprise that typical Database setups are the main target of the hacking attacks worldwide. The reason is obvious: cracking a database will result in access to the data which is the main ‘merchandise’ to be shared or sold on the dark corners of the World Wide Web.

May 25, 2020

SQL*Plus Client connections to several Oracle Autonomous (Always-Free)

Oracle Autonomous is a great service and Always-Free is a nice offering launched at OpenWorld 2019. But what happens if I need to connect via SQL*Plus to two or more ADB from the same machine/terminal? The Oracle documentation provides good reference usable when connectiong to one autonomous database but if we need to use several…

February 19, 2020

It is now possible to clone a database in Autonomous Cloud

Database cloning, very handy feature, is now available for Oracle’s Autonomous Cloud.

March 20, 2019

Oracle Autonomous Transaction Processing: Client Setup

a. First step is the database creation. Quite straightforward:

March 20, 2019