Database Star: Home

How To Turn On and Use SQL Developer DBMS_OUTPUT

Aug 20, 2015 · 4 min read · sql ·

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 ·

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.

Oracle ADD_MONTHS Function with Examples

Aug 6, 2015 · 5 min read · sql-functions ·

Share on:

In this article, I'll explain how the very useful ADD_MONTHS function works and use some examples.

How To Use the SQL Developer Format SQL Options

Aug 5, 2015 · 5 min read · sql ·

Share on:

In this article, I'll explain what formatting SQL is, and how to find the SQL Developer Format SQL options.

How To Turn On or Off SQL Developer Autocommit Settings

Jul 10, 2015 · 3 min read · sql ·

Share on:

In this article, I'll explain what the SQL Developer Autocommit feature is, where to find it, and how to turn it on or off.

How To Turn On Line Numbers in SQL Developer

Jul 8, 2015 · 2 min read · sql ·

Share on:

In this article, I'll show you what line numbers are in SQL Developer and how to turn this setting on.

SQL NULLIF Function Explained with Examples

Jun 18, 2015 · 5 min read · sql-functions ·

Share on:

The SQL NULLIF function is available in many vendors. Let's take a look at what NULLIF does and what you can use it for.

Oracle SUBSTR Function Explained with Examples

May 23, 2015 · 8 min read · sql-functions ·

Share on:

The Oracle SUBSTR function is used to get a smaller string (the substring) from within a larger string. Let's take a look at how you can use it and some examples.

Oracle LISTAGG Function Usage, Tips & Examples

May 14, 2015 · 9 min read · sql-functions ·

Share on:

This article explains the Oracle LISTAGG functions, which is one of the more difficult functions to understand. Purpose of the Oracle LISTAGG Function The purpose of the Oracle LISTAGG function is to allow you to perform aggregation of strings from data in columns. What is string aggregation? Well, it's a technique …

How to Convert Data Types in Oracle SQL

May 5, 2015 · 5 min read · sql ·

Share on:

When using Oracle SQL, there are many ways to convert data types. Three of the most common data types are string (VARCHAR2), number, and date. Let's take a look at how you can convert to these types.