Database Star: Home

Oracle CONVERT Function Explained with Examples

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

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.

How To Turn On and Use SQL Developer DBMS_OUTPUT

Aug 20, 2015 · 4 min read · sql ·

Share on:

In this article, I'll explain what the DBMS_OUTPUT function is and how it works in SQL Developer.

How To Use The SQL Developer Export Connections With Passwords Function

Aug 13, 2015 · 3 min read · sql ·

Share on:

Oracle's SQL Developer tool lets you export a list of connections that you have created. This is great for saving time for your team. Learn how you can do that in this article.