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 already enabled: The feature is supported at different levels: column table schema session database statement In this post, we will […]

Read More →

Overview: 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. We use a table with 9 000 000 rows and seelct from it with a sample percentage of 0.0001 We […]

Read More →