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…

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 Download the mac kit from the Oracle site. Unzip the kit into the correct directory: % unzip Downloads/sqlcl-23.1.0.089.0929.zip -d Applications…

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. I work on an great autonomous TP instance and it is…

I speak at SPOUG ’21

Oracle Autonomous and Data Lake Accelerator Below you can see the details of your session, including the scheduled time of your session:  Session Code: SP21DBSEINF001Name: Radu PârvuEmail: radu.parvu@accenture.com Position: DirectorTwitter: https://twitter.com/rparvuLinkedin: https://www.linkedin.com/in/rparvu/Bio: Radu has over 21 years of experience in various database projects (mainly Oracle but other DBMS,…

How to monitor SQL with Oracle SQL Developer

The easiest way to monitor the SQL's currently executing

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…

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. First, a few considerations re implementation of the security…

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…

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…

It is now possible to clone a database in Autonomous Cloud

Database cloning, very handy feature, is now available for Oracle’s Autonomous Cloud. Quite easy to implement, too: The options are:

Oracle Autonomous Transaction Processing: Client Setup

a. First step is the database creation. Quite straightforward: b. Next step is to a connection setup connection from local client: from the main datbase page we click the DB Connection button and download the client credentials: A zip archive…

%d bloggers like this: