Sql | Database Star: Home

How to Calculate the Mean, Median, and Mode in Oracle

Dec 25, 2017 · 6 min read · sql ·

Calculating the mean, median, and mode in Oracle SQL is a task often performed by report developers or anyone else working with SQL. Learn how to calculate these three values from a range of data in this article.

The Complete Guide to Oracle Sequences

Nov 13, 2017 · 11 min read · sql ·

Share on:

In this article, I’ll explain what an Oracle sequence is, how to create one, and how to use them.

The Complete Guide to Oracle Synonyms

Oct 23, 2017 · 7 min read · sql ·

Share on:

In this article, I’ll explain all you need to know about Synonyms.

What Are The DML, DDL, and TCL Commands in SQL?

Sep 25, 2017 · 5 min read · sql ·

Share on:

There are three main types of SQL statements in SQL. Learn what they are and what the commands are in this article.

How to Escape Single Quotes in SQL

May 1, 2017 · 4 min read · sql ·

Share on:

Do you need to escape special characters or escape a single quote in SQL? Learn how to do that in this article.

TNSNAMES.ORA File - The Complete Guide

Apr 10, 2017 · 8 min read · sql ·

Share on:

The TNSNAMES.ORA file is an important file when working with Oracle. Learn all about what it is, its location, and how to create and edit it in this article.

SQL Glossary of Terms

Mar 30, 2017 · 48 min read · sql ·

Share on:

SQL, and database development in general, contains a lot of terms and acronyms. Check out this SQL glossary to help understand them.

SQL ORDER BY - The Complete Guide

Mar 20, 2017 · 9 min read · sql ·

Share on:

The SQL ORDER BY clause and functionality is an important part of a SELECT statement. Learn what it does and how to use it in this article.

The Difference Between WHERE and HAVING Clause

Mar 13, 2017 · 4 min read · sql ·

Share on:

What is the difference between WHERE and HAVING clause in SQL? Learn what they are and the differences in this article.