Database Star: Home

Oracle DUMP Function Explained with Examples

Dec 17, 2015 · 4 min read · sql-functions ·

The Oracle DUMP function tells you the data type of an expression. Let's learn how to use it and see some examples in this article.

88 of the Best Programmer Jokes

Nov 30, 2015 · 20 min read · programming ·

Share on:

In this article, I've listed a whole bunch of programmer jokes that only programmers will understand!

Oracle CONVERT Function Explained with Examples

Nov 26, 2015 · 4 min read · sql-functions ·

Share on:

The Oracle CONVERT function doesn't do what you might expect it do, if you just look at its name. Learn what this function does and how to use it in this article.

How to Start an SQL Developer Debug Session

Nov 23, 2015 · 5 min read · sql ·

Share on:

Learn how to use the SQL Developer debug feature.

Oracle TRANSLATE Function Explained with Examples

Nov 19, 2015 · 5 min read · sql-functions ·

Share on:

The Oracle TRANSLATE function is a similar function to REPLACE, but it has a few differences. Learn what the differences are and see some examples in this article.

SQL RANK and DENSE_RANK: Function Guide, FAQ, and Examples

Nov 12, 2015 · 11 min read · sql-functions ·

Share on:

In this article, you'll learn everything about the SQL RANK and DENSE_RANK functions that are available in Oracle, SQL Server, MySQL, and Postgres.

Using the SQL Developer Export Functionality for Data and Query Results

Oct 22, 2015 · 4 min read · sql ·

Share on:

In this article, I'll explain how you can use the SQL Developer export functionality.

Oracle TO_TIMESTAMP Function with Examples

Oct 8, 2015 · 3 min read · sql-functions ·

Share on:

The Oracle TO_TIMESTAMP function is useful if you need to work with timestamp data types. Learn how to use it with some examples in this article.

How To Use and Run The SQL Developer Execution Plan

Sep 30, 2015 · 3 min read · sql ·

Share on:

One of the most valuable features for writing SQL queries is seeing how long it will take to run and how efficient it is. In SQL Developer, there's an option called "Explain Plan". Let's see how that works.

185 Software Development Acronyms

Aug 24, 2015 · 14 min read · work-performance ·

Share on:

In the world of software development, we use and see a lot of acronyms. In this article, I've listed a lot of common acronyms, along with definitions, which can help your understanding in the workplace.