Test Post

Posted by Gavin Soorma
On November 27, 2014
1 Comments

Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post .Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post .Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post .Test Post Test Post Test Post Test […]

Posted by Gavin Soorma
On November 14, 2014
0 Comments

If we are dealing with large amounts of data and have to use queries to find count of distinct values of some particular column or group of columns, the new 12.1.0.2 feature APPROX_COUNT_DISTINCT function can be significantly faster than using the traditional COUNT (DISTINCT expr) function with marginal differences in the exact result. The examples […]

Posted by Gavin Soorma
On November 12, 2014
0 Comments

In Oracle 12c when we create a table we can populate a column automatically via a system generated sequence by using the GENERATED AS IDENTITY clause in the CREATE TABLE statement. We can use GENERATED AS IDENTITY with the ALWAYS, DEFAULT or DEFAULT ON NULL keywords and that will affect the way or when the […]

News

Test Post

Oracle 12c new feature APPROX_COUNT_DISTINCT and FETCH FIRST ROWS

Oracle 12c New Feature IDENTITY Columns