Sql-Functions

SQL CHR, CHAR, ASCII, NCHR, NCHAR, and ASCIISTR Function Guide, FAQ, and Example

Dec 23, 2017 · 6 min read · sql-functions ·

The SQL CHR, CHAR, ASCII, NCHR, NCHAR, and ASCIISTR functions are useful when translating between text characters and their ASCII codes. Learn all about these functions in this article.

SQL INSTR Functions Explained with Examples

Dec 22, 2017 · 5 min read · sql-functions ·

Share on:

In this article, we’ll look at the INSTR function (including its variants), explain how to use it, and see some examples.

SQL GREATEST and LEAST Function Guide, FAQ, & Examples

Dec 21, 2017 · 6 min read · sql-functions ·

Share on:

The SQL GREATEST function and LEAST function are quite useful, but not very well understood. Let’s take a look at these functions and see some examples in this article.

SQL POWER and SQRT Function Guide, FAQ & Examples

Dec 20, 2017 · 3 min read · sql-functions ·

Share on:

In this article, we’ll look at both the POWER and SQRT functions, explain how they work, and see some examples.

Oracle TRIM, LTRIM & RTRIM Function Guide, FAQ & Examples

Dec 11, 2017 · 13 min read · sql-functions ·

Share on:

In this article, you’ll learn all about the three TRIM functions in Oracle (TRIM, LTRIM, and RTRIM).

SQL LEAD and LAG Function Guide, FAQ, and Examples

Dec 6, 2017 · 10 min read · sql-functions ·

Share on:

The SQL LEAD function and SQL LAG function can be very useful for finding data in your result set and simplifying your queries. Learn all about them in this article.

Oracle NEXT_DAY and LAST_DAY Function Guide, FAQ, and Examples

Nov 26, 2017 · 5 min read · sql-functions ·

Share on:

The Oracle NEXT\DAY and LAST_DAY functions are similar functions used to determine dates. Learn more about what they can do and their differences in this article.

SQL CEIL and FLOOR Function Guide, FAQ, and Examples

Nov 18, 2017 · 4 min read · sql-functions ·

Share on:

The SQL CEIL function and FLOOR function are opposites of each other and are very useful functions when dealing with numbers. Learn what they are and see some examples in this article.

The Complete Guide to Oracle REGEXP Functions

Nov 6, 2017 · 27 min read · sql-functions ·

Share on:

Are you confused by Oracle regular expressions? Want to know how to use them to get the information you need for your queries? Learn all about Oracle REGEXP functions in this article.

Oracle SYSDATE Function Guide, FAQ, & Examples

Oct 30, 2017 · 6 min read · sql-functions ·

Share on:

Oracle SYSDATE is one of the most popular functions in Oracle. Learn what it does and how to SELECT and INSERT it in this article.