Tech and other topics
Archives
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…
Read MoreSQL*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…
Read MoreOverview: SELECT SAMPLE
One feature that many developers and data analysts are not aware of is the SAMPLE function in Oracle. It is quite an old feature (not sure exactly when it was added). Below is a simple example of how it works….
Read MoreBlog Posts I Liked
I am an Oracle ACE since 2019
Recent Comments