Brendan Tierney - Oralytics Blog
Pages
(Move to ...)
Blog
My Books
Consulting Services
Oracle Magazine Collection
Shop
Contact Me
▼
Showing posts with label
Function
.
Show all posts
Showing posts with label
Function
.
Show all posts
Wednesday, November 12, 2014
Approximate Count Distinct (12.1.0.2 new feature)
›
With the release of the Oracle Database 12.1.0.2 there was a number of new features and options. Most of the publicity has been around the i...
Wednesday, July 30, 2014
Tokenizing a String : Using Regular Expressions
›
In my previous blog post I gave some PL/SQL that performed the tokenising of a string. Check out this blog post here. Thanks also to the p...
Thursday, July 24, 2014
Tokenizing a String
›
Over the past while I've been working a lot with text strings. Some of these have been short in length like tweets from Twitter, or long...
Tuesday, November 6, 2012
Adding numbers between two values
›
My son asked me the other day, what is the total number if you add all the numbers between Zero and 100. We could have sat down to work it ...
Thursday, November 1, 2012
ASCII to character conversion in Oracle
›
Here is code code that will produce formatted output of the characters and their ascii values. The formatting is broken into lower case lett...
›
Home
View web version